SQL query in Excel vba -> CAST problem

[rene oudeman]

Hi,

i am working with the excel sql database as in the example on this site.
(adodb connection to the worksheet)
it works just fine, but i am having trouble doing bitwise checks.

"WHERE CAST([group_desc$].[category_id1] as UNSIGNED INTEGER) & " & tmpCat_1 & " <> 0;"

-> tmpCat is a number to test for

(the isnot sign is eaten by the markup somehow)

anyone an idea?

 

[NARAYANK991]

Hi Rene ,

Would it be :

"WHERE (CAST([group_desc$].[category_id1] as UNSIGNED INTEGER) & " & tmpCat_1 & ") <> 0;"

with the two additional brackets ?

Narayan

 

[Colin Legg]

Hi,

What driver are you using? I doubt that Cast() is a valid function and that Unsigned Integer is a valid data type.
Also I'm not sure what the ampersand in the string after the cast is meant to do?

Perhaps post your full code / link to sample file?

 

[rene oudeman]

Hi,

I fixed it. I am running the stuff in excel tables, and the formating can be changed in the cells. It works now.
Thanks,

Rene