[thelist] Updateable query? ASP DSN-less access connection
Tab Alleman
talleman at RealMetros.com
Tue Mar 26 14:37:01 CST 2002
Is it possible that their copy of the db has a typo in one of the column
names, or is missing a column or mis-defining a column?
Can you try a dsn-less connection running the script on your server, but
calling the database on their server via the IP?
..my 2 shots in the dark.
-----Original Message-----
From: Edward George [mailto:edward at suppose.co.uk]
Sent: Tuesday, March 26, 2002 8:06 AM
To: thelist at lists.evolt.org
Subject: Re:[thelist] Updateable query? ASP DSN-less access connection
This is a multi-part message in MIME format.
--
[ Picked text/plain from multipart/alternative ]
They're pulled out of a form, here's a test one
INSERT INTO Events
(Headline,Body,ImgLink,ImgPrevLink,ImgAlt,Entry,Expiry,Descr) VALUES
('test','test','test','test','test','test','29/03/2002','test')
All fields are text apart from Body which is a memo.
As mentioned it breaks only on their server but works fine here.
thanks
Ed,
ed at suppose.co.uk
http://ed.suppose.co.uk
http://www.suppose.co.uk
Paul Backhouse Tue Mar 26 06:55:01 2002
I would need to see what your queries are.
--
--
For unsubscribe and other options, including
the Tip Harvester and archive of thelist go to:
http://lists.evolt.org Workers of the Web, evolt !
More information about the thelist
mailing list