Akopia Akopia Services

[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date ][Interchange by thread ]

[ic] SQL search problem



Hi,
Somebody can tell, whether I can use
a _'_ character inside the SQL-request?

If i said :

[query ml=10 more=1 list=1
 query="
 select sku, title, price, authors, pubdate, category
 from products
 where authors = '[value f_value]'"
]

and inside the [value f_value] meets _'_ character,
browser show "Internal Server Error" (500), because
line of SQL-request terminated on a _'_ -character!

Please, help!

_______________________________________________
Interchange-users mailing list
Interchange-users@lists.akopia.com
http://lists.akopia.com/mailman/listinfo/interchange-users


Search for: Match: Format: Sort by: