var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Urgent ASP help required
I am trying to add a new record to an oracle database from a form on the previous page. Here is the bit i'm having problems with:
<%Do While Not (objRs.EOF)%>
<option value="<%=objRs("artist_id")%>"> <%=objRs("artist_name")%></option>
option value is a number pulled from the database. The problem is when i submit the form to this asp page:
Dim strartist, strobjConn
objConn.execute("insert into artists values('"& strartist &"'"))
it doesnt recognise the option value as a number and returns the error invalid number. What am i doing wrong
Really need urgent help please?
Well you have wrapped your value in quotes so oracle will think it is meant to be a string would be my first bet, try....
objConn.execute("insert into artists values("& strartist &")")
Aha!! problem solved, thanks!