It (the query) doesn't seem to like the * wildcard...

huh??

B

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Byron J. Bignell
Sent: Thursday, July 04, 2002 12:24 PM
To: [EMAIL PROTECTED]
Subject: [CFTALKTor] blind


Ok.  I'm blind.  Has anyone else run into this error:

 Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver]Value can not be converted to requested type.
 
The Error Occurred in C:\Inetpub\wwwroot\MFD\dwtest.cfm: line 11

9 : 
10 : <body>
11 : <table width="75%" border="1">
12 :   <cfoutput query="qryItems">
13 :     <tr> 

SQL    SELECT * FROM tblitems
DATASOURCE   auction
SQLSTATE   HY000

Simple qyery, CFMX, SQL 2000 SP2...

...sigh...


Byron



-
You are subscribed to the CFUGToronto CFTALK ListSRV.
This message has been posted by: "Byron J. Bignell" <[EMAIL PROTECTED]>
To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/
Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/
This System has been donated by Infopreneur, Inc.
(http://www.infopreneur.net)



-
You are subscribed to the CFUGToronto CFTALK ListSRV.
This message has been posted by: "Byron J. Bignell" <[EMAIL PROTECTED]>
To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/
Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/
This System has been donated by Infopreneur, Inc.
(http://www.infopreneur.net)

Reply via email to