Solved

System.Exception: Unsupported TYPE attribute: Bit  Problem

Posted on 2004-10-05
3
270 Views
Last Modified: 2010-04-25
i keep getting these errors when i upload the pages to the server , while they work perfect on my local server

System.Exception: Unsupported TYPE attribute: Bit
at DreamweaverCtrls.DataSet.GetDbTypeFromString(String str)
at DreamweaverCtrls.DataSet.AddParameters(IDbCommand myCommand)
at DreamweaverCtrls.DataSet.DoInit()

please i need your help


for example see www.palpeople.org/english

0
Comment
Question by:daouddajani
3 Comments
 
LVL 9

Accepted Solution

by:
prifre earned 250 total points
ID: 12241781
I have not really a solution, but on
http://www.charon.co.uk/aspnetforums/ShowPost.aspx?PostID=2040

they write:
"This is probably because I'm moving from asp (recordsets) to asp.net (datasets) and I'm not fully aware of the differences in queries! When developing for asp I always used the advanced query option and hand typed my queries, but in asp.net they don't work the same.

In my SQL query I had the following which didn't work:

SELECT *
FROM dbo.orderinfo
WHERE orderid = @orderid

with the following params
Name: @orderid
Type: Integer
Value: IIf((Not Session("orderid") Is Nothing), Session("orderid"), "")

I flipped from 'Advanced' to 'Simple' in the DataSet window and let it generate the following

SELECT *
FROM dbo.orderinfo
WHERE orderid = ?

............ with the following params
Name: @orderid
Type: Integer
Value: IIf((Not Session("orderid") Is Nothing), Session("orderid"), "")

This now works .............. I guess it's all part of the learning and transition to .net. I'm now treading very carefully!"

might that help?

with a smile
/prifre
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Set up local email server on Macbook w/CF 5 390
Dreamweaver not "Putting" files to server 15 605
Regular Expressions find/replace needed 10 143
Jquery submit form question 11 101
For those who don't know, Adobe Dreamweaver is a popular commercial web editor that enables you to design, build and manage complex websites. The editor is a WYSIWYG (What You See Is What You Get) web editor, which means that you can create your web…
Adobe Dreamweaver CS5 is a WYSIWYG web page editor that has advanced HTML, CSS, and Javascript rendering functionality and is probably the most well-known HTML editor available. Much of Dreamweaver's appeal centers around the Design View interfac…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

806 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question