Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

System.Exception: Unsupported TYPE attribute: Bit  Problem

Posted on 2004-10-05
3
Medium Priority
?
278 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
1 Comment
 
LVL 9

Accepted Solution

by:
prifre earned 1000 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

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

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

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…
This article is very specific and is only intended to help if you are installing Dreamweaver 8 in a Windows 7 environment with Office 2007 installed.   I'm not sure why Microsoft tends to release OS' that should not be released but they do.  Windows…
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

578 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