Hello,
I have got a problem, When i try to connect to Sybase from PHP script, I
have an error that I am calling undefined function sybase_connect.
Does it meen that I have to load some extra module to get this function to
work? Or what should I do to resolve this problem ?
Thank you.
--
With Interbase functions I have to make 2 select.
SELECT count(*).. to count valid record
and
SELECT * .. to extract the records
There is a simple solutions to have unique Select ?
I use Pgsql too but here I Have the pg_numrows variable.
Someone sau to me:
just make the SELECT * .. to extract
Hi everybody,
I have a little question. What is the best datatype to put large character data into
(more than 5.000-20.000 letters). Maybe a CLOB or a long ? I am quiet new to oracle so
I don't know so much about the LOBs and how Oracle handles it. On thing is, that I
have to use more than
This is my page to extract image (from blob) in a interbase table.
I call it with :echo src=\blob2img.php?id_product=.$id_product.\ ;
?php
//BLOB2JPG
$conn = ibase_connect($host,$user,$pass,$charset,$buffers,$dialect,$rules)
$set = ibase_query(SELECT IMAGE from products where (id_product =
Andy:
Go with the CLOB. As you stated, you can have more than one CLOB defined in
a table. Also, you can pull out data randomly instead of sequentially. Plus,
the data can reside inline (for less than 4KB) or out of line for bigger
values.
The key to making it work is using the DBMS_LOB
Cordialement / Regards Christophe
ChassagneuxIngénieur / Développeur ProgressTel:
0144 641 300Fax: 0144 641 301Mail: [EMAIL PROTECTED]
The error message is:
-
Cadastro de Fornecedor
Warning: SQL error: [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionTransact
(TransactNamedPipe())., SQL state 01000 in SQLExecDirect in
Patrick Callihan [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
I don't seem to have the *.so modules available. When I added the line
'extension=php_dba.so' to php.ini, nothing changed. When I tried to use
the
dl() function, I just got an error message:
I'm running a local web server for development on my Win ME machine
using apache, mysql 3.23.38, and php4. I've been copying my mysql
database that is online to my local one every once in a while. When the
database starting getting greater than 1mb I remember the mysql
filename.sql wouldn't work
It sounds like the problem you are having is the same one I had. There is a
variable in the php.ini called upload_max_filesize that the default max size
in here is 2Mb, so when importing or exporting a dump file that is over 2Mb,
it will not work. Try changing this in your php.ini file and see
It works great! However, even though my .sql file was only 2.4 mb, it
took nearly 15 minutes to import it all. I expect to be working with
20mb files in the not too distant future. Will it really take over two
hours? Is this mysql's fault or the fault of my POS 500mhz WinME
machine? Anyone know?
I have several files I import daily using phpMyAdmin, the biggest of which is
over 4Mb and it only takes 5-10 seconds, but both machines (my pc-750Mhz Win98
and the server) are on the same network. If you are using dialup to access
it, that could be why it is taking longer. Otherwise, I would
I have some data in a table like this:
++--+
| services | machine_name |
++--+
| MS Exchange Server and BDC | MAIL |
| Microsoft Exchange for UA | UAMAIL1 |
| Microsoft Exchange for
Ya, I understand that. But when I want to view all services then I get
three output for Microsoft Exchange. I want only one at that time. And
click that service and I can get the machine name.
On Wed, 1 Aug 2001, John Pickett wrote:
If I understand you correctly you might try a query like:
Ariadne,
This appears to be an error in the driver itself, but without a trace I
cannot be sure.
Best regards,
Andrew
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 01, 2001 10:52 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject:
Installing a current libtools rpm seems to have corrected the situation.
Rick
Rick Hickerson wrote:
I'm at wit's end.
../php-4.0.6/configure gives an error, and debug.log says libclntsh.so: don't
use llseek, use lseek64, and slpmprodstab is undefined.
I've looked everywhere. All of
Sharif Islam [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Is there any way, I can get only one output.But somehow I have to
incorpate it with the other data in that column, which doesn't have
multiple entry. Any hint? thanks in advance.
!DOCTYPE HTML
This should be a simple insert. I must be missing something because I keep
getting: Couldn't execute query.
What am I missing?
?
error_reporting(15);
$db_name = dbname;
$table_name=company;
$connection = @mysql_connect(servname,username, password)or die
(Couldn't connect.);
$db =
If you simplify the query you'll see your error...all those escaped were
giving me a headache hehe
snip
*modified*
$add_co_sql = INSERT INTO $table_name
(CompanyID, CompanyName, Address, City, StateorProvince,
PostalCode,Region,Country,WebSite)VALUES
I'm running a local web server for development on my Win ME machine
using apache, mysql 3.23.38, and php4. I've been copying my mysql
database that is online to my local one every once in a while. When the
Since you're using relatively recent version of MySQL might I suggest you
setting up
Steve
I believe you're missing the closing bracket ) after $Website.
I think it's clearer if you use single quotes (') rather than double quotes
and then having to escape them.
Something like:
INSERT INTO $table_name
(CompanyID, CompanyName, Address, City, StateorProvince,
Well, I have made it a little further. I could not get it to configure
using the --with-db2 switch even after installing the sleepycat software. I
did succeed in compiling php using the --with-gdbm switch. After that I had
a module called dba.so. I put that in the proper place and changed the
With the help of another friend, I now have it working. The problem was I
needed to make the directory and file group apache and then give them both
group write permission. It works! I thought I would post this in case
someone else ran across the same problem.
Patrick
Patrick Callihan
What is the best method for avoiding multiple ids for the same information.
For example: I have a table name company that has unique ids. The CompanyID
are tied to a table name contacts which have unique ids (ContactID). The
problem seems to be that if I add a contact with an existing
I belive this UPDATE should work, but it isn't. I get no errors. I have also
tried using FieldName= '$Fieldname', but that does not seem to work either.
$table_name = contacts;
$update_contact_sql = UPDATE $table_name
SET
FirstName =\$FirstName\,
LastName = \$LastName\,
Title = \$Title\,
Isn't PHP/MySQL case sensitive? Are all the column names the correct
case?
You could also try changing your die bit to
or die (mysql_error());
that will echo the MySQL error message.
HTH!
Dave
-Original Message-
From: Steve Fitzgerald [mailto:[EMAIL PROTECTED]]
Sent: 01 August
G'Day All,
I need to establish connectivity between a Debain Linux box running PHP
4.06 and Oracle 8i running on a Win32 box. Can someone point me at some
FAQ's or other help. At present I have managed to get MS-SQL 2K going using
TDS (Tabular Data Stream). Could TDS also be used for Oracle?
I have a timestamp field that looks like this
0109011754
but I only want to compare
010801
when doing a SELECT. Is there a way I can do this? Thanks.
Jeff Oien
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL
$fulldate = date(dmy);
echo $fulldate;
-Original Message-
From: Jeff Oien [mailto:[EMAIL PROTECTED]]
Sent: 01 August 2001 23:34
To: PHP-DB
Subject: [PHP-DB] Limit Select Field Characters?
I have a timestamp field that looks like this
0109011754
but I only want to
Hello,
is it possible with InterBase to fire a select statement against an empty
table witout getting in trouble.
if the table X looks like this:
id - integer
dummy - varchar
and if I do now a select like
select * from x where id='$id';
I will get the error
Warning: InterBase:
left(timestamp,6)
- Original Message -
From: Jeff Oien [EMAIL PROTECTED]
To: PHP-DB [EMAIL PROTECTED]
Sent: Wednesday, August 01, 2001 11:33 PM
Subject: [PHP-DB] Limit Select Field Characters?
I have a timestamp field that looks like this
0109011754
but I only want to compare
What exactly does the error 'REG_EMPTY' mean in PHP?
--
-Adam Lundrigan
CEO, VPU
http://www.vpu-virtual.com/
ICQ # 73617446
[EMAIL PROTECTED]
Does isset() work for objects? If not, is there a similar function for
objects?
Thanks
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL
select * from table where date_format(timestamp, '%y%m%d') = '010801'
Jeff Oien [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
I have a timestamp field that looks like this
0109011754
but I only want to compare
010801
when doing a SELECT. Is there a way I
Steve Fitzgerald [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
What is the best method for avoiding multiple ids for the same
information.
For example: I have a table name company that has unique ids. The
CompanyID
are tied to a table name contacts which
Donovan J. Edye [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
G'Day All,
I need to establish connectivity between a Debain Linux box running PHP
4.06 and Oracle 8i running on a Win32 box. Can someone point me at some
FAQ's or other help. At present I have
I have a form and based off of this form if my user selects option a then I
want them to be redirected to another page. If they select option B then I
want to continue with my php scrips as it does now.
Does any one have any ideas on how I can accomplish this?
--
PHP Database Mailing List
Hello!!!
Here try this
if ($DATABASE===Custom)
{
$table=Table1;
}
if ($DATABASE===Return_Log)
{
$table=table=3;
$DATABASE=Return_Log;
echo (HTML);
echo (HEAD);
echo (TITLE $us On Linux Using Apache/TITLE);
echo (/HEAD);
echo
OPPS WRONG SENDER HAHAHAHAHA!
I'm a little absent minded
Hello!!!
Here try this
if ($DATABASE===Custom)
{
$table=Table1;
}
if ($DATABASE===Return_Log)
{
$table=table=3;
$DATABASE=Return_Log;
echo (HTML);
echo (HEAD);
echo (TITLE $us
?
if $option_button == 1) {
header(Location: some_page_or_other.php);
} else {
header(Location: some_other_page_you_choose.php);
}
?
that's all you need - make sure the form on the previous page has two
radiobuttons, each with the same
40 matches
Mail list logo