Instr problems

I have a page that uses a session variable that stores items like a shopping cart, all this works fine but i am trying to code a button that removes an item, i have a page that i have set up for the remove function and have tried the following code

this returns an error like this

this is returning an error

Microsoft VBScript runtime error '800a01c2'

Wrong number of arguments or invalid property assignment: 'instr'

not sure where to go from here as i know nothing about this

all i want to do is click on a button on the page that will send the variable recordNum from a form on the page back to the page and remove the numbers contained in this variable

e.g.
session variable = 1,2,3,4,5,6,7,8,9

recordNum = 4

click the button and remove 4 so that the session variable = 1,2,3,5,6,7,8,9

hope i have explained this properly

re: Instr problems

As a minimum amount of arguments, you need to provide instr() with the string to search and the string to find.

So:

Looking at it though I think replace() or split() may be better options.

For example using split you could add each recordNum to an array then loop through it adding each one back to your session variable except the one you don't want.

For example

Gaz

re: Instr problems

I understand this but it is returning an error with the sql statement that uses the session variable??

i have added a response.write on the last line and it is removing the item numbers but leaving the commas? how can i get rid of them as they must be causing the problem

any ideas it worked with the old code

re: Instr problems

Can you post here the session variable before and after the items have been removed so I can take a look see?

I probably just need to modify the loop slightly (I didn't test it!)

Never mind that.

I copied the code from here and modified it.

This prduces 1,2,3,5,6,7,8,9,10 either with or without a trailing comma in the initial variable.

Just change my variables to yours.

Gaz

re: Instr problems

This is the session variable from the page previous to the delete page

0,1634,2089,1638,1633,

this is the error i get when i try and delete an item on the delete page

[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'idnumbermp3 in (0,1634,2089,1633,,)'.

the can be seen if you follow one of the artists on the following link
www.yaketyyakallmouth.com/pages/boys.asp?id=all

not sure why the 0 is at the front either but thats always been there

re: Instr problems

That now produces 0,1634,2089,1638,1633 using the modified loop in my prior post.

Can you test that now?

re: Instr problems

I now have

this works fine, but if i go back to another artist after deleting something it does not have a comma in the middle of the old number and the new one?

re: Instr problems

hi it now works i removed the -1

its now

re: Instr problems

just wondering if anyone could help with something else, i want to change the image of the button used to add something to the cart if it exists in the cart already

the code used to add to the cart is the following

<%

if InStr(session("recordsInCart"), ","&request.form("recordNum")) = 0 then
session("recordsInCart") = session("recordsInCart") + request.form("recordNum") &","
else
'do nothing
end if
%>

and the form that contains the button is

i know this must be really simple just to ask if the id number is in the session variable and then say the image is......

just not that good with asp

re: Instr problems

hi

Using my session("recordsInCart") could i find if my number stored in recordNum is in it and then change a picture depending on it, its so i can have the button that adds to the cart show a different picture if its already in the session variable

sorry ive already asked you this!!!!!

re: Instr problems

re: Instr problems

Hi
I think i understand what you mean, i have tried to code it so that depending on the Instr result it writes a different line of code for the submit button, only problem is that no button appears, im sure ive done something wrong in my code

re: Instr problems

For troubleshooting purposes and readability, take it out of the response.write. Usually this type of error is just a result of too many quote marks in the response.write. Remember that HTML is much more straight-forward, so if you can write it all int plain HTML do it.

re: Instr problems

changed it to straight HTML and its works fine thanks for your help