| |
| |
| |
|
Comments:
<0> why does this not work SQL = "INSERT INTO MyTable SET value1 = '" & Request("value1") & "' AND value2 = '" & Request("value2") & "' "
<1> "it does not work"
<1> is not a valid proble
<1> Describe the problem, and give an error message
<1> do that first, next time, too. you're more likely to get help
<0> no error
<0> goes through fine
<0> but does not add to the database
<1> yep, it'll error
<1> You have an On Error Resume Next in there, don't youi?
<0> this seems to work fine though SQL = "INSERT INTO MyTable SET value1 = '" & Request("value1") & "' "
<0> nope
<1> That first line of code you pasted will error
<1> Lookup the syntax of an INSERT statement
<0> but when i add the AND value2 = '" & Request("value2") it stops working
<1> Because an INSERT statment is not formed like that
<0> i know it's insert into tablename values( 'value1', 'value2', 'value3' ect)
<0> was hopping it could be though
<1> Then... why the hell are you trying to do that?
<1> Well, is it working?
<1> No.
<1> Then no, it is not like that
<1> You can't just make up your own syntax and expect something to work
<0> lol ok ok calm down
<2> you should validate any user input prior to processing it
<2> the INSERT syntax is... INSERT INTO tablename (Col1 [, Coln]) VALUES(Val1 [, Valn])
<0> ya i have it working just don't like the syntax for it but i guess that my prob
<0> no biggy
<0> thanks though
<3> hey
<4> hi all
<5> !free
<5> hello ^^
<6> sorry, !commercial only
<6> you pay with irc dollars
<5> ?
<7> tool
<8> anyone have an idea how to figure out from a string like this name0=&quantity0=&price0=&myloopcount0=myloopcount0&name1=&quantity1=&price1=&myloopcount1=&name2=&quantity2=&price2=&myloopcount2=
<8> to figoure out how many times to loop through it?
<8> figure = figoure
<8> in that example it would need to do a for 0 to 3 loop
<9> no problem, create an array using split
<9> Items = Split(string, "&")
<9> then you can use a For-loop with LBound/UBound on Items to get lower/upper bounds
<8> just messing around with what you are saying it sounds good in theory
<9> for i = 0 To UBound(items) ... next
<9> that'll do the trick
<8> Mac, how do I extrapolate from the Items string the "myloopcount"?
<8> i guess it doesn't really matter
<9> you do anothe rsplit on =
<9> :D
<9> that's an url or cookie-string right?
<8> yeah
<8> URL string
<9> you do know that you have builtin functions for that?
<9> the Request.QueryString collection
<8> to determine the number of times I would need to loop through the varibles in order to do multiples inserts to a db?
<9> oh nasty
Return to
#asp
or
Go to some related
logs:
hissandpop.com
#nhl
hotman with peni
#unixhelp
#nhl
#computers
#nhl
#sex
#beginner
#beginner
|
|