Re: [ cf-dev ] string and numeric

2003-11-27 Thread Bo Jiang
all")# Select * from user Cheers guys, good luck Bo Jiang - Original Message - From: "Robin Griffiths" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, November 27, 2003 3:30 PM Subject: Re: [ cf-dev ] string and numeric Try u

Re: [ cf-dev ] string and numeric

2003-11-27 Thread Robin Griffiths
Try using the preserveSingleQuotes() function - Original Message - From: Bo Jiang To: [EMAIL PROTECTED] Sent: Thursday, November 27, 2003 1:43 PM Subject: Re: [ cf-dev ] string and numeric Hi, Please, any body can give me a clue about my question? Is that infeasible in

Re: [ cf-dev ] string and numeric

2003-11-27 Thread duncan . cumming
nt.ucd.ie> cc: Subject: Re: [ cf-dev ] string and numeric

Re: [ cf-dev ] string and numeric

2003-11-27 Thread Bo Jiang
November 27, 2003 9:04 AM Subject: [ cf-dev ] string and numeric > Hi, > I am doing two functions in CF a component. One has arguments all in numeric, it > works fine, another has some arguments in string, when I quote the variable in a > SQL, it says syntax error. As far as

[ cf-dev ] string and numeric

2003-11-27 Thread Bo Jiang
Hi, I am doing two functions in CF a component. One has arguments all in numeric, it works fine, another has some arguments in string, when I quote the variable in a SQL, it says syntax error. As far as I can see, that because the single quotation marks are converted to double quotation marks au