Hello all ,
Pl check if the foll query is correct or not ,
mySql = "SELECT description, details, listPrice, map, imageUrl, imageUrl2, imageUrl3, imageUrl4, sku, formQuantity, hasPersonalization, freeShipping, isDonation, searchKeywords, user1, user2, user3,categories.categoryDesc as categoryDesc FROM (products join categories_products on categories_products.idProduct=products.idProduct) join categories on
categories_products.idCategory = categories.idCategory WHERE idProduct=" &pidProduct& " AND active=-1 AND idStore=" &pIdStore &"
This is very urgent as i am trying this from last 2 hrs & get stuck again & again
I am getting the error as
Microsoft VBScript compilation (0x800A0409)
Unterminated string constant
Thanxs in advanced
Sheetal J
|
| Author: Roopesh Babu Valluru 16 Oct 2008 | Member Level: Gold | Rating:  Points: 1 |
I didnot get y u used (...)..except that everything looks fine for me... .. i am not sure but try to remove that and run the application ... hope it will work...
All The Best...
|
| Author: RDRaja 25 Oct 2008 | Member Level: Silver | Rating: Points: 5 |
Try this Query
---------------
mySql = "SELECT description, details, listPrice, map, imageUrl, imageUrl2, imageUrl3, imageUrl4, sku, formQuantity, hasPersonalization, freeShipping, isDonation, searchKeywords, user1, user2, user3,categories.categoryDesc as categoryDesc FROM (products join categories_products on categories_products.idProduct=products.idProduct) join categories on
categories_products.idCategory = categories.idCategory WHERE idProduct=" &pidProduct& " AND active=-1 AND idStore=" &pIdStore
Remove the &" Characters
By
RdRaja
|