lfernand
Posts: 19
|
| Posted: 03/11/2009, 1:54 PM |
|
Hi,
I want to make a condition on visual query builder, its a simple equal in sql.
Something like
md5(table.id::varchar) = id(from url)
The problem is that CCS put quotes on my sentence, this trigger a database error on postgres.
"md5(table.id::varchar)" = id(from url)
Error: "md5(table.id::varchar)" is not a column
The only way to eliminate the quotes is elimnating the dot, but I cant do that, since there are several tables with the ID column.
Any ideas?
|
 |
 |
datadoit
|
| Posted: 03/11/2009, 5:15 PM |
|
See if it'll take the ` character:
`md5(table.id::varchar)` = id(from url)
|
|
|
|
lfernand
Posts: 19
|
| Posted: 03/12/2009, 11:32 AM |
|
datadoit, thanks for the reply, but I couldnt make it work. CCS continues to put quotes (" ") on the sentence.
|
|
|
|
|
