Graham Anderson wrote:
Wow. I feel really dumb.
I thought (incorrectly) that the surrounding quotes would screw with the
variables in the ADODB's INSERT statement.
many thanks
G
On Aug 7, 2007, at 2:06 PM, Uber Wannabe wrote:
-Original Message-
From: Graham Anderson [mailto:[EMAIL
Wow. I feel really dumb.
I thought (incorrectly) that the surrounding quotes would screw with
the variables in the ADODB's INSERT statement.
many thanks
G
On Aug 7, 2007, at 2:06 PM, Uber Wannabe wrote:
-Original Message-
From: Graham Anderson [mailto:[EMAIL PROTECTED]
Sent: Tuesda
On Tue, August 7, 2007 3:34 pm, Graham Anderson wrote:
> What is the proper way to get the ADODB class to automatically add
> quotes to the below sql ?
> I'm guessing that the below fails because none of the variables get
> quoted with the method, qstr.
>
> $sql = "insert into email (to_name, to_em
-Original Message-
From: Graham Anderson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 07, 2007 3:34 PM
To: php-general
Subject: [PHP] ADODB Insert Question (Syntax)
Hi
What is the proper way to get the ADODB class to automatically add
quotes to the below sql ?
I'm guessing that the
On 6/7/06, weetat <[EMAIL PROTECTED]> wrote:
Hi all ,
I am having problem in store session in the database . Below is the
example code from code.
Ask the adodb guys.
http://adodb.sourceforge.net/#mail
--
Postgresql & php tutorials
http://www.designmagick.com/
--
PHP General Mailing List
Gabe wrote:
It sort of did. It may have corrected that error, but now I get a new
error:
Warning: odbc_exec(): SQL error: [Microsoft][ODBC Microsoft Access
Driver] Operation must use an updateable query., SQL state S1000 in
SQLExecDirect in d:\adodb\drivers\adodb-odbc.inc.php on line 504
S100
Thanks Dave. It's working now. I searched many different places for an
answer and yet for whatever reason, I just didn't check Google. We're
all allowed a few brain mishaps, right? :-)
Thanks again.
David O'Brien wrote:
After googling the error message for you, I found about a zillion pag
After googling the error message for you, I found about a zillion pages
which all basically say the same thing.
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q175168
-Dave
At 11:01 AM 4/21/2004, Gabe wrote:
Here's another version of the SQL statement and I get a different
error now. W
At 11:01 AM 4/21/2004, you wrote:
Here's another version of the SQL statement and I get a different
error now. When I copy and paste this exact same SQL statement into an
update query in Access it works fine. When I try to use it in my PHP
code, I get the following error:
SQL Statement:
UPDATE t
Here's another version of the SQL statement and I get a different
error now. When I copy and paste this exact same SQL statement into an
update query in Access it works fine. When I try to use it in my PHP
code, I get the following error:
SQL Statement:
UPDATE tblFAQ_Book SET fldTitle = 'one mor
It sort of did. It may have corrected that error, but now I get a new
error:
Warning: odbc_exec(): SQL error: [Microsoft][ODBC Microsoft Access
Driver] Operation must use an updateable query., SQL state S1000 in
SQLExecDirect in d:\adodb\drivers\adodb-odbc.inc.php on line 504
S1000: [Microsoft
Gabe wrote:
I double checked the names. Everything looks okay. Another ideas?
Did the ADOdb list answer not work?
http://phplens.com/lens/lensforum/msgs.php?id=9285
Single and double quotes can be a problem in SQL.
--
Lester Caine
-
L.S.Caine Electronic Services
--
P
From: "Gabe" <[EMAIL PROTECTED]>
> I double checked the names. Everything looks okay. Another ideas?
> >>(access): UPDATE tblFAQ_Book SET tblFAQ_Book.fldTitle = "one more test"
> >>WHERE (tblFAQ_Book.autoBookID = 1)
> >>
> >>Warning: odbc_exec(): SQL error: [Microsoft][ODBC Microsoft Access
> >
I double checked the names. Everything looks okay. Another ideas?
Curt Zirzow wrote:
* Thus wrote Gabe ([EMAIL PROTECTED]):
...
(access): UPDATE tblFAQ_Book SET tblFAQ_Book.fldTitle = "one more test"
WHERE (tblFAQ_Book.autoBookID = 1)
Warning: odbc_exec(): SQL error: [Microsoft][ODBC Microsof
* Thus wrote Gabe ([EMAIL PROTECTED]):
> ...
> (access): UPDATE tblFAQ_Book SET tblFAQ_Book.fldTitle = "one more test"
> WHERE (tblFAQ_Book.autoBookID = 1)
>
> Warning: odbc_exec(): SQL error: [Microsoft][ODBC Microsoft Access
> Driver] Too few parameters. Expected 1., SQL state 07001 in
> SQLE
[snip]
I'm trying to do a simple update to an access database using the ADOdb
library.
Any help is much appreciated!
[/snip]
What error message are you getting? You are outputting an error message
when queries fail, aren't you? Does the connected user have permission
to perform updates on the sp
That helps, thanks!
"Curt Zirzow" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> * Thus wrote Gabe ([EMAIL PROTECTED]):
> > If you're using ADOdb, what is the name, purpose, and function of this
> > operator?
> >
> > ->
> >
> > e.g. $conn->Connect(false, 'scott', 'tiger', $oraname)
* Thus wrote Gabe ([EMAIL PROTECTED]):
> If you're using ADOdb, what is the name, purpose, and function of this
> operator?
>
> ->
>
> e.g. $conn->Connect(false, 'scott', 'tiger', $oraname);
The $conn variable is a adodb object that has methods and
properties associated with it. The -> tells ph
Yeah, I looked at that page, but didn't see any specifications for it. I
guess I'll probably just have to use the tried and true method of "trial and
error".
Thanks Matt.
"Matt Matijevich" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> [snip]
> e.g. $conn->Connect(false, 'scott',
I tried the URL you supplied but I didn't see any reference to the operator
in question. I hope I'm not blind
"Alex Hogan" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> > If you're using ADOdb, what is the name, purpose, and function of this
> > operator?
> >
> > ->
> >
> > e
> If you're using ADOdb, what is the name, purpose, and function of this
> operator?
>
> ->
>
> e.g. $conn->Connect(false, 'scott', 'tiger', $oraname);
>
> I can follow some tutorials, but I'm just not sure when I need to use it
> and
> when I don't.
This is an explanation that's in the manual.
[snip]
e.g. $conn->Connect(false, 'scott', 'tiger', $oraname);
[/snip]
http://www.php.net/oop will give you some help.
I am not even sure if I can explain it correctly.
I believe you would say use -> to call object methods and -> to get/set
the class variables. I am sure someone can give a bett
Would each virtual host need to have a directory with the ADOdb scripts?
No
Just put the adodb scripts in the include_path, or just have a
designdated place on your windows bow for adodb, then in you include
statement just use something like
include('c:\adodb\adodb.php'); //not exactly sure wha
Hello
Did you compile mysql or any of the other databases into php5? As far as I
know php5 does not come with mysql anymore because of some licence issues.
So if you haven't compiled it yourself it shouldn't be available and hence
not supported by adodb.
Just a guess
Regards
Stefan Langer
adodb layer.
php.weblogs.com/adodb
- Original Message -
From: "Jay Blanchard" <[EMAIL PROTECTED]>
To: "Gilberto Garcia Jr." <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, September 08, 2003 5:45 PM
Subject: RE: [PHP] adodb and php5
[snip]
Does
[snip]
Does anyone had tested ADODB with php5?
[/snip]
D'oh **slapping forhead** I shouldn't be driving this late on Monday
afternoon.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
From: "Gilberto Garcia Jr." <[EMAIL PROTECTED]>
> Does anyone had tested ADODB with php5?
> I can make a query, print the recordcount but when i try to show the
result i got nothing
>
> while (!$qry->EOF) {
> echo $qry->fields['campo'] . "";
>
> $qry->MoveNext();
> }
You might want to ask on the
[snip]
Does anyone had tested ADODB with php5?
I can make a query, print the recordcount but when i try to show the
result i got nothing
PConnect('some', 'some', 'some', 'some');
[/snip]
You do not need the ADODB connection if you are using MySQL. Are you
connecting to Access or MS SQL? If you
One thing that has helped me was to write a db class and use it to connect
to mysql, then all you have to do is change the class, and not all your code
when you change the db.
-Steve
-Original Message-
From: Brendon G [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 24, 2002 4:03 AM
To
I've been using it for about 4 months and it's very stable.
=C=
*
* Cal Evans
* Journeyman Programmer
* Techno-Mage
* http://www.calevans.com
*
-Original Message-
From: Jerome Houston [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 17, 2002 4:05 PM
To: [EMAIL PROTECTED]
Subject: [PHP] ADO
30 matches
Mail list logo
