partially processing recordset?

[HakanAzaklioglu]

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

[Mark Sreeves]

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.