Problem with mysql and ASP

[Mark Schupp]

You probably need to change the date format you are using. #date# is used in
MS Access but I don't think it is valid for MySQL. Check the MySQL docs.

--
Mark Schupp
--
Head of Development
Integrity eLearning
Online Learning Solutions Provider
[email]mschupp@ielearning.com[/email]
[url]http://www.ielearning.com[/url]
714.637.9480 x17


"Passero" <yanongena@pandora.be> wrote in message
news:R926b.2390$tN3.140426@phobos.telenet-ops.be...

> When i want to execute a insert into statement i get following error:
>
> Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
> [MySQL][ODBC 3.51 Driver][mysqld-4.0.14-nt]Er is iets fout in de gebruikte
> syntax bij '' in regel 1
>
> I translate it: there is an error in the used syntax by '' in rule 1
>
> The code i use is: conn.execute query
>
> I suppose that they mean that my querystring is empty? However when i

write

> response.write query i get the following:
>
> insert into gebruikers values
>

('name','name2','userID','pasword',#01\10\1982#,'m ail@mail.com','0','M','cou

> ntry','city','student','url','icq','msn','hobby',' info','more',#5\1\2003#)
>
>
>
> I guess that it is correct? So why won't it work?
>
>
>

[Mark Schupp]

You probably need to change the date format you are using. #date# is used in
MS Access but I don't think it is valid for MySQL. Check the MySQL docs.

--
Mark Schupp
--
Head of Development
Integrity eLearning
Online Learning Solutions Provider
[email]mschupp@ielearning.com[/email]
[url]http://www.ielearning.com[/url]
714.637.9480 x17


"Passero" <yanongena@pandora.be> wrote in message
news:R926b.2390$tN3.140426@phobos.telenet-ops.be...

> When i want to execute a insert into statement i get following error:
>
> Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
> [MySQL][ODBC 3.51 Driver][mysqld-4.0.14-nt]Er is iets fout in de gebruikte
> syntax bij '' in regel 1
>
> I translate it: there is an error in the used syntax by '' in rule 1
>
> The code i use is: conn.execute query
>
> I suppose that they mean that my querystring is empty? However when i

write

> response.write query i get the following:
>
> insert into gebruikers values
>

('name','name2','userID','pasword',#01\10\1982#,'m ail@mail.com','0','M','cou

> ntry','city','student','url','icq','msn','hobby',' info','more',#5\1\2003#)
>
>
>
> I guess that it is correct? So why won't it work?
>
>
>

[Passero]

"Mark Schupp" <mschupp@ielearning.com> schreef in bericht
news:eAx#2o8cDHA.2368@TK2MSFTNGP09.phx.gbl...

> You probably need to change the date format you are using. #date# is used

in

> MS Access but I don't think it is valid for MySQL. Check the MySQL docs.
>

I've checked on [url]www.mysql.com[/url] and this is what they said:

Observe that MySQL expects dates in 'YYYY-MM-DD' format; this may be
different from what you are used to.

Knowing that, i've changed my code an indead it works. I used to work with a
MDB with my asp pages but now i've changed.
Thanks a lot.

> --
> Mark Schupp
> --
> Head of Development
> Integrity eLearning
> Online Learning Solutions Provider
> [email]mschupp@ielearning.com[/email]
> [url]http://www.ielearning.com[/url]
> 714.637.9480 x17
>
>
> "Passero" <yanongena@pandora.be> wrote in message
> news:R926b.2390$tN3.140426@phobos.telenet-ops.be...

> > When i want to execute a insert into statement i get following error:
> >
> > Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
> > [MySQL][ODBC 3.51 Driver][mysqld-4.0.14-nt]Er is iets fout in de

gebruikte

> > syntax bij '' in regel 1
> >
> > I translate it: there is an error in the used syntax by '' in rule 1
> >
> > The code i use is: conn.execute query
> >
> > I suppose that they mean that my querystring is empty? However when i

> write

> > response.write query i get the following:
> >
> > insert into gebruikers values
> >

>

('name','name2','userID','pasword',#01\10\1982#,'m ail@mail.com','0','M','cou

> >

ntry','city','student','url','icq','msn','hobby',' info','more',#5\1\2003#)

> >
> >
> >
> > I guess that it is correct? So why won't it work?
> >
> >
> >

>
>

[Passero]

"Mark Schupp" <mschupp@ielearning.com> schreef in bericht
news:eAx#2o8cDHA.2368@TK2MSFTNGP09.phx.gbl...

> You probably need to change the date format you are using. #date# is used

in

> MS Access but I don't think it is valid for MySQL. Check the MySQL docs.
>

I've checked on [url]www.mysql.com[/url] and this is what they said:

Observe that MySQL expects dates in 'YYYY-MM-DD' format; this may be
different from what you are used to.

Knowing that, i've changed my code an indead it works. I used to work with a
MDB with my asp pages but now i've changed.
Thanks a lot.

> --
> Mark Schupp
> --
> Head of Development
> Integrity eLearning
> Online Learning Solutions Provider
> [email]mschupp@ielearning.com[/email]
> [url]http://www.ielearning.com[/url]
> 714.637.9480 x17
>
>
> "Passero" <yanongena@pandora.be> wrote in message
> news:R926b.2390$tN3.140426@phobos.telenet-ops.be...

> > When i want to execute a insert into statement i get following error:
> >
> > Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
> > [MySQL][ODBC 3.51 Driver][mysqld-4.0.14-nt]Er is iets fout in de

gebruikte

> > syntax bij '' in regel 1
> >
> > I translate it: there is an error in the used syntax by '' in rule 1
> >
> > The code i use is: conn.execute query
> >
> > I suppose that they mean that my querystring is empty? However when i

> write

> > response.write query i get the following:
> >
> > insert into gebruikers values
> >

>

('name','name2','userID','pasword',#01\10\1982#,'m ail@mail.com','0','M','cou

> >

ntry','city','student','url','icq','msn','hobby',' info','more',#5\1\2003#)

> >
> >
> >
> > I guess that it is correct? So why won't it work?
> >
> >
> >

>
>

[Deepak Kumar Vasudevan]

Hi:

#string# notation stands for date? But I think they work in Microsoft Access driver.

I suppose you should use YYYY-MM-DD notation for MySQL.

[url]http://php.weblogs.com/[/url] gives API for MySQL. You may like to check it out too.

--
================================
Deepak Kumar Vasudevan
CS Software Solutions

Phones: +91-44-2819-1336 thru 38
91-98400-26014
[url]www.cssolutionsinc.com[/url]
================================
"Passero" <yanongena@pandora.be> wrote in message news:R926b.2390$tN3.140426@phobos.telenet-ops.be...
When i want to execute a insert into statement i get following error:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[MySQL][ODBC 3.51 Driver][mysqld-4.0.14-nt]Er is iets fout in de gebruikte
syntax bij '' in regel 1

I translate it: there is an error in the used syntax by '' in rule 1

The code i use is: conn.execute query

I suppose that they mean that my querystring is empty? However when i write
response.write query i get the following:

insert into gebruikers values
('name','name2','userID','pasword',#01\10\1982#,'m ail@mail.com','0','M','cou
ntry','city','student','url','icq','msn','hobby',' info','more',#5\1\2003#)



I guess that it is correct? So why won't it work?

[Deepak Kumar Vasudevan]

Hi:

#string# notation stands for date? But I think they work in Microsoft Access driver.

I suppose you should use YYYY-MM-DD notation for MySQL.

[url]http://php.weblogs.com/[/url] gives API for MySQL. You may like to check it out too.

--
================================
Deepak Kumar Vasudevan
CS Software Solutions

Phones: +91-44-2819-1336 thru 38
91-98400-26014
[url]www.cssolutionsinc.com[/url]
================================
"Passero" <yanongena@pandora.be> wrote in message news:R926b.2390$tN3.140426@phobos.telenet-ops.be...
When i want to execute a insert into statement i get following error:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[MySQL][ODBC 3.51 Driver][mysqld-4.0.14-nt]Er is iets fout in de gebruikte
syntax bij '' in regel 1

I translate it: there is an error in the used syntax by '' in rule 1

The code i use is: conn.execute query

I suppose that they mean that my querystring is empty? However when i write
response.write query i get the following:

insert into gebruikers values
('name','name2','userID','pasword',#01\10\1982#,'m ail@mail.com','0','M','cou
ntry','city','student','url','icq','msn','hobby',' info','more',#5\1\2003#)



I guess that it is correct? So why won't it work?