[thelist] ASP using SQL but anoing me like $%&#

[Warden, Matt]

> ok, but where is the semicolon supposed to be?
> if I add Response.Write strsql this is what I get:
>
> insert into vinstri (name) values ('Félagsstarf')(url)
> values ('felagsstarf.html')(menu) values ('elmenu1')(order)
> values ('1')
>
> it seems to be holding the values correctly, I simply just
> don't know where I'm supposed to add the semicolon.
>
> | Or, try this:
> |
> | objRS.Open strsql & ";"
>
> this did nothing, it still asked for a semicolon.

That's because you're SQL is bunkedified. Try this:

insert into vinstri (name, url, menu, order) values ('Félagsstarf',
'felagsstarf.html', 'elmenu1', '1')

or:

insert into vinstri (name, url, menu, order) values ('Félagsstarf',
'felagsstarf.html', 'elmenu1', '1');

(just an added semicolon)


--
mattwarden
mattwarden.com