-
I am pretty sure this is sound code... Except until it goes to process the end of the code
Instead of getting back a list of only items in the database the have a CPU identifier in the itemtype column of my database it returns everything with out referencing the itemtype column.
I would like it to only return items with the cpu.* or for example cpu, cpuup or cpuold in the itemtype column that is why i wanted to use LIKE
rsCPUCNT.OPEN "SELECT * FROM TVIMAIN WHERE SYSCAT LIKE '%" & REQUEST.QUERYSTRING("SYSTEMID") & "%' AND ITEMTYPE LIKE '%" & CPU & "%'", CONN, 3
Please Advise,
Hakan
-
Sorry, can't help.
but...
Personally, I would compose the SQL string to a variable first so I could check exactly what the query is.