Ask a Question related to Coldfusion - Advanced Techniques, Design and Development.
-
obxlefty #1
Query on Query and CF casting problem
I am using a custom tag in MX7 that was working fine in 5 that renders a table.
The input to the custom tag is a query and it's columns along with some
formatting. If a column of data begins with all numerics and then later in the
data some text appears, the cfquery (query on the passed in query) tag throws
an error that the text cannot be converted to a number. I didn't want it to be
a number in the first place. If the first item includes non-numeric
characters, it performs fine.
In the thrown exception, I see that CF "guesses" that this column is of type
double and when it runs into the text, it blows up. Is there any way to
override this? I tried appending some text, "", to the front but this didn't
work.
obxlefty Guest
-
Query of Query problem
Error Executing Database Query. Query Of Queries runtime error. Table named "DATA" was not found in Memory. It is misspelled, or the table is... -
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... -
CAML Query: Multiple Query Fields Issue
I need to Create a CAML Query Dynamically with VB to a Sharepoint WebService GetListItems Method. The User Could Select 1 to X Number of IDs... -
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 Quote

