Ask a Question related to Coldfusion - Advanced Techniques, Design and Development.
-
dannyra #1
Another Query of Query cast error
Just in case somebody else is getting this error I thought I'd leave this here.
I have a shopping cart that is stored in a session variable. When at item is
added or updated I do a sum of the quantity with a group by. I kept getting a
casting error on the quantity field even when I set the quantity=0 in the code.
I ended up having to do <cfset session.cart.quantity[row]=val(0)> instead of
<cfset session.cart.quantity[row]=0> I thought this was really weird,but hopes
this saves somebody else some trouble.
dannyra Guest
-
Query of Query Error
This is the error I get - Query Of Queries syntax error. Encountered ". Query Of Queries runtime error. The Cold Fusion server is running MX... -
Query of Queries on query New type query
In CF5 we have a page that creates a query, using queryNew and querySetCell and the like, we then used dbtype="query" and gave it's name so we could... -
Convert a query to a list, or find an item in a query
Hi All, I am using CFPOP to retrieve mail from a server, then delete each message after I retrieve it. What I want to do is to check that I don;t... -
Clob Datatype Cast for Queries on Query
Hi , I am getting a Query of Queries runtime error when I try to do a QoQ on query which has a column with the clob datatype. The original query is... -
BCP query out executed by xp_cmdshell works fine from query analyzer but fails from VB Component
Hi all, I have a stored procedure which returns a vast number of record and i have to write the output into a csv file. I'm using BCP utility to...
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
