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 below fails because none of the variables get
quote
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 below fails because none of the variables get
quoted with the method, q
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 tha
Hi
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_email, from_name, from_email,
subject, message, timestam
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
Hi all ,
I am having problem in store session in the database . Below is the
example code from code.
The issue is that the code run ok , however the expireref fields is not
updated in the sessions table, below is the sessions schema :
CREATE TABLE `sessions` (
`sesskey` varchar(32) NOT
Hi,
Can someone tell me what are the differences between ADODB and using the
compiled-in MSSQL extension? Which one is faster? What are the
benefits/pitfalls of using either?
Thanks
Dean.
i've searched on the internet about my problem that i
have, and ended up with nothing. i believe some of u
guys have faced this problem before.
here is the problem:
i have a table for books, and want to display it using
adodb-pager.
this is my select state: select * from books where
booktitle lik
Hello,
ADOdb is a popular database abstraction library for PHP. It supports
a very large number of databases, including MySQL, PostgreSQL,
Firebird, Interbase, SQLite, Oracle, Frontbase, DB2, SAP DB, Sybase,
Informix, Netezza, Access, VFP, MS SQL, LDAP, ODBTP, ODBC, etc.
Due to system outages at
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
I'm trying to do a simple update to an access database using the ADOdb
library. For some reason I can't get it to work. I can however, get a
simple select statment to work just fine. Take a look at my code below
as well as the error message. Maybe someone can help me out. As you'll
see bel
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',
gt; This is an explanation that's in the manual.
>
> $conn->Open("Provider=SQLOLEDB; Data Source=localhost;Initial
> Catalog=database; User ID=user; Password=password");
>
> http://www.php.net/manual/en/ref.com.php
>
>
>
> alex hogan
>
>
> >
> From: Gabe [mailto:[EMAIL PROTECTED]
> Sent: Thursday, April 08, 2004 1:43 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP] ADOdb Operator question
>
> If you're using ADOdb, what is the name, purpose, and function of this
> operator?
>
> ->
>
> e.g. $conn->
[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
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.
Thanks
--
PHP General Mailing List (http://www.php.net/)
To un
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
For those of you that are using ADOdb, hopefully you can help me out. I'm
evaluating PHP on IIS and I was curious if I had to have a directory with
the ADOdb scripts for every virtual host?
For example, if I had three virtual hosts at three different IP's:
210.210.210.200
210.210.210.201
210.210
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
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');
$seleciona = "
select campo
from tabela
";
$qry =& $conn->Execute($seleciona);
if (!$qry) {
echo $conn->ErrorMsg();
echo
Somebody here use adodb with oracle?
I´m triyng to use that, but I´m noting realize how to estabilish a conection
with oracle.
I´m getting the folowing error:
Fatal error: Call to undefined function: ora_plogon() in
e:\inetpub\wwwroot\hosted\EnsinoNet\php\adodb\drivers\adodb-oracle.inc.php
on
To: [EMAIL PROTECTED]
Subject: [PHP] ADOdb
Just curious as to what the general consensus of opinion is on the following
class. Do many of you use it?.
http://php.weblogs.com/ADOdb
Coming over to PHP from ASP (I'm not really interested in learning .Net at
the moment) I like that I can s
Just curious as to what the general consensus of opinion is on the following
class. Do many of you use it?.
http://php.weblogs.com/ADOdb
Coming over to PHP from ASP (I'm not really interested in learning .Net at
the moment) I like that I can switch databases allot faster if the need
occurs by us
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]
Sub
Testimonial time!
Despite ROCK STAR assistance from a PHP developer, I'm having troubles with
mssql_*() functions. most of the problems are gone (or being fixed by some
AWESOME people), but to make use of those fixes, i've got to use php v
4.3-dev. and there's other bugs in that (as there sh
is there a source for further information
connecting to databases with ADODB for PHP4?
I only know http://php.weblogs.com/ADODB
--
WA-P : Jochen Kaechelin
Programmierung - Beratung - Hosting
Stuttgarter Strasse 3, D-73033 Göppingen
Tel. 07161 - 92 95 94, Fax 92 95 98
--
PHP General Mailing L
Anyone made good experiences
with the ADODB Library for PHP4?
--
WA-P : Jochen Kaechelin
Programmierung - Beratung - Hosting
Stuttgarter Strasse 3, D-73033 Göppingen
Tel. 07161 - 92 95 94, Fax 92 95 98
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
http://php.weblogs.com/adodb
Database wrapper library 1.10. Now supports cached recordsets.
Example below:
include('adodb.inc.php');
include('tohtml.inc.php');
$ADODB_CACHE_DIR = '/usr/local/adodbcache';
$conn = &ADONewConnection('oracle');/* Oracle 8, use 'oci8' */
$conn->PConnect('','scott','
45 matches
Mail list logo
