On Sunday 03 February 2002 03:47, Todd Williamsen wrote:
I want the date to automatically be updated. So if a post was made on
2/10/2001 I would like it to put it automatically in the database.
I do have a column called Date and the datatype is set to date. But when
I add a record even if
Hi sirs, I'm trying to run include() function to include a page from a
different website, but it fails :
include(http://remote/dawn-travel/lists/somelongnumber.xml;);
remote is windows NT4 IIS
I got the following error,
Warning: Failed opening
Hi sirs, I'm trying to run include() function to include a page from a
different website, but it fails :
include(http://remote/dawn-travel/lists/somelongnumber.xml;);
remote is windows NT4 IIS
I got the following error,
Warning: Failed opening
Hi,
I don't have a direct solution to the problem, but I would use Oracle's
Multi-Threaded Server and switch to using normal non-persistent PHP
connections. Eg. rely on Oracle to do the connection pooling instead
of PHP.
My benchmarks suggest that this is quite an efficient method of
connecting
hi...trying to circumvent the limitation of the DELETE
statement only being able to use its own table...idea
is to mark the records to be deleted via an UPDATE
statement which allegedly accepts LEFT JOIN and then
performing the DELETE statement.
Question is how to properly form a LEFT JOIN using
[EMAIL PROTECTED] (Adv. Systems Design) writes:
Question is how to properly form a LEFT JOIN using
UPDATE... I tried:
UPDATE product_price LEFT JOIN temp
SET product_price.product_price_vdate = 1 (del flag)
ON product_price.product_id = temp.product_id
WHERE temp.product_id IS NOT NULL
Hi guys,
I would like to display something like: please wait, searching while I am
making a querry or other stuff which takes a while. After the work is done,
it should redirect to another page displaying the result.
As far as I know the HEADER location satement is only valid if there is no
After looking at the newsgroup microsoft.public.sqlserver.odbc I came
across
the follwing piece of information - anyone know if it is true? It would
certainly explain a few things (why we can only get 255 chars out of
varchars etc). Should I move my code over to ODBC? I have tried but the
on 2/3/02 3:36 PM, Lutz Brückner at [EMAIL PROTECTED] appended the following
bits to my mbox:
Question is how to properly form a LEFT JOIN using
UPDATE... I tried:
UPDATE product_price LEFT JOIN temp
SET product_price.product_price_vdate = 1 (del flag)
ON product_price.product_id =
I am working on a rideboard and I am trying to figure out how to take information from
a mysql database and place it in the e-mail I am trying to send out.
Basically I want the e-mail to look similar to this:
Name: John Doe
Phone: 555-
State: New York
and so on.
Anyway the mail
I don't want the file to be stored in the database, but its location.
What I want to do:
Upload a file, it gets stored on the webserver, but its location on the
server is stored in the database.
Where do I look for something like this?
What data type would I use to store the URL or file
Technically, it is not the dblib interface that limits you to 255
character varchars. TDS (tabular datastream, the on the wire protocol)
version 4.2 (the version used upto SQL Server 6.5) is limited to a single
byte size field and thus 255 characters (0 represents NULL). The problem
is
Hello!!!
You can do something like this
$pat = array(#, @, *, , %, @,$,',`);
$w= '_';
$pic_name2 = str_replace ($pat, $w, stripslashes($pic_name));
$query = INSERT INTO Travel_Design (Tavel_Design, Design_Name,
Season, Date, name, filesize, filetype )
Hi,
I want to save and load images as binaries with a MySQL database, but I'm
not sure how to do it. I'm sure this is a very dumb question, but forgive
me for being a newbie =)
Tim
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Well... thanks to Dan Burner for the script... BUT
I cannot get this friggin INSERT statement to execute.. which craps out..
I cannot figure it out. I have been staring at it for about an hour and I
still cannot figure it out
here it is:
$db = @mysql_select_db($db_name, $connection) or
hello all,
i'm trying to make a script where i can do a mass insert to database (4,000 entries)
and then send confirmation email to each of the entry's email address stating that
their record has been inserted to database. My problem is, when i use a while loop the
page time-out on the 300th
You missed the SET parameter in your query... example is below...
$query = INSERT INTO Canidate SET (FirstName, LastName, Indus...
Adam
-Original Message-
From: Todd Williamsen [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 04, 2002 11:06 AM
To: [EMAIL PROTECTED]
Subject: Re: FIle
Umm..
SET parameter is for the UPDATE query
Adam Royle [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
You missed the SET parameter in your query... example is below...
$query = INSERT INTO Canidate SET (FirstName, LastName, Indus...
Adam
-Original
Hi there everyone,
I need to generate a random number between 1 and 15 for insertion into a DB, I can
easily do the DB side of it but what is the best method for quickly generating a
random number between 1 and 15 (including 1 and 15 in the equation)?
Thanks for all your help.
Regards
Chris
On sön, 03 feb 2002, Chris Payne wrote:
Hi there everyone,
I need to generate a random number between 1 and 15 for insertion into a
DB, I can easily do the DB side of it but what is the best method for
quickly generating a random number between 1 and 15 (including 1 and 15
in the
Hi there,
That is absolutely PERFECT, thank you so much for that you are a lifesaver
:-)
Regards
Chris Payne
www.planetoxygene.com
On sön, 03 feb 2002, Chris Payne wrote:
Hi there everyone,
I need to generate a random number between 1 and 15 for insertion into a
DB, I can easily
See the set_time_limit() function in the php manual.
-Jason Garber
IonZoft.com
At 10:22 AM 2/4/2002 +0800, J-E-N wrote:
hello all,
i'm trying to make a script where i can do a mass insert to database
(4,000 entries) and then send confirmation email to each of the entry's
email address
22 matches
Mail list logo
