2. ASPRunnerPro General questions
  3. SQL query
This topic is locked

SQL query

 		11/18/2008 3:55:49 PM
ASPRunnerPro General questions
A
 alfabravo author

I'm trying to make an SQL query with the following statement but I keep getiing an error, the main idea is to replace comma with a dot in the cprice column:
SELECT

catalogid,

ccode,

cname,

cdescription,

REPLACE(cprice,',','.') AS price,

cimageurl,

extraimage4,

extraimage5

FROM products
I'll apreciate any help

Thanks
J
 		Jane 11/19/2008

Hi,
your query looks correct.

Where do you edit this SQL query?
A
 		alfabravo author 11/19/2008

Hi,

your query looks correct.

Where do you edit this SQL query?


Thanks for your replay Jane, I edited the SQL query at the start of the asprunner programme (Edit SQL Query).
Thanks for your help