Ask a Question related to Coldfusion Database Access, Design and Development.
-
bwellisch #1
queryparam doesn't work?!?
Hi,
I appear to be having a problem with cfqueryparam. If I use it my query
returns the wrong value for some reason.
I have a very simple table like so:
users_groups
------------------
userID - varchar(35)
groupID - integer
The following works:
<cfquery name="groups" datasource="mydsn">
SELECT ug.groupID
FROM user_groups ug
WHERE ug.userID = 'D99EECD9-BDB5-781A-3B2CBFB687946532'
</cfquery>
<cfoutput>#groups.groupID#</cfoutput>
The output is 1, as it should be. However, when I do this...
<cfquery name="groups" datasource="mydsn">
SELECT ug.groupID
FROM user_groups ug
WHERE ug.userID = <cfqueryparam
value="D99EECD9-BDB5-781A-3B2CBFB687946532" cfsqltype="CF_SQL_VARCHAR">
</cfquery>
<cfoutput>#groups.groupID#</cfoutput>
The output is inexpicably 4294967297 !
What's going on? Any advice would be appreciated!
bwellisch Guest
-
why does this not work?
This CFFILE was supposed to not overwrite an exsisting image with the same name but rather generate an error. but it did overwrite the image. for... -
How does it work?
How does contribute work? The product explanation and tutorial was incomplete. Does the developer and the client both need to purchase the... -
Links don't work in Shockwave movie but work in p
Hi, everyone: I encountered a strange problem. I downloaded a sample movie from Macromedia site and noticed that the same problem occurs what I had... -
ASP won't work at all
Even attempting to load the simplest ASP page on an intranet I get the "Server Application Error - The server has encountered an error while... -
net use from Dos donīt work
Hey to all, I tried several hours to get a connect from DOS (network boot disc) to my new XP Laptop. I used: net use Z:... -
bwellisch #2 Re: queryparam doesn't work?!?
Upgrading the jdbc driver solved the problem!
bwellisch Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
