RE: FN-FORUM ASP opportunity

date posted 29th September 2002 15:41

commandtext is not on the connection object
just put it in execute statement

dmdTemp.Execute("INSERT blaaaa....")

:) Ant.

-----Original Message-----
From: [EMAIL REMOVED]
[EMAIL REMOVED] Behalf Of john anslow
Sent: 29 September 2002 12:48
To: [EMAIL REMOVED]
Subject: FN-FORUM ASP opportunity


Hi guys,

need a bit of help from the asp gurus amongst you.

I'm using a direct connection to an access db which works fine for
select statements but errors for inserts, here's the code I'm using and
the error I'm getting.

Can anyone cast any light on why it's not working?


Set dmdTemp = Server.CreateObject("ADODB.Connection")
dmdTemp.Provider = "Microsoft.Jet.OLEDB.4.0"
dmdTemp.ConnectionString = "Data
Source=d:websitessitenamefolderdatadtabase.mdb;"
dmdTemp.Open
dmdTemp.CommandText="INSERT INTO `homepage`
(description,twso,price)VALUES('"+description+"','"+twso+"',''"+price+"')"
dmdTemp.CommandType=1
dmdTemp.Execute

gives me the following error

Microsoft VBScript runtime error '800a01be'

Object doesn't support named arguments: 'CommandText'

/cccomputing/scripts/addahp.asp , line 18

TIA,

John
--

Fatfriar Productions

"With you every step of the way"

Website Design and Production at a reasonable rate and with a level of
service second to none.

Web: http://www.Fatfriar.com E-mail: [EMAIL REMOVED]

Telephone: +44 (0)208 405 4151

Mobile telephone: +44 (0)7798 746 685

Go Beyond Your Limitations...


The information in this message is confidential and may be legally
privileged. It is intended solely for the addressee. Access to this
message by anyone else is unauthorised. If you are not the intended
recipient, any disclosure, copying, or distribution of the message, or
any action or omission taken by you in reliance on it, is prohibited and
may be unlawful. Please contact the sender immediately if you have
received this message in error. Thank you.



============================================================
= Advanced web hosting solutions from Saffas. =
= Unix, PHP, mySQL, SSL, Perl, Control Panel, 24/7 access. =
= Why pay more for less? http://www.saffas.com =
============================================================

Sponsor the forum for as little as #1 at:

http://www.freelancers.net/cgi/sponsor.cgi?action=show


Advertise with Freelancers.net +Additions+

http://www.freelancers.net/advert.php


Freelancers and Freelance Jobs:
http://www.freelancers.net

Forum FAQs:
http://freelancers.netrickery.com

To unsubscribe please email:
[EMAIL REMOVED]

If you have difficulties unsubscribing please email:
[EMAIL REMOVED]