December 9th, 2002, 08:03 AM
|
|
Junior Member
|
|
Join Date: Dec 2002
Posts: 1
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
Stored procedure in SQL2000
I'm trying to use PHP to execute a stored procedure on SQL Server 2000 - I'm only trying to insert data in the two fields that comprise a single table (starting small!):
My table is called MeetMinutes and is defined as:
NameOfFile VARCHAR
MeetDate SMALLDATETIME
Because PHP doesn't have a DATE type, I'm using SQLVARCHAR in both mssql_bind statements.
My php fragment:
PHP Code:
$Init=MSSQL_INIT("UpdateMinutes",$Link)
or die("Couldn't initialise the procedure");
MSSQL_BIND($Init,"@Filename",$Filename,SQLVARCHAR,FALSE,FALSE,50)
or die("Could not send the name of the file to the procedure");
MSSQL_BIND($Init,"@MeetDate",$MeetingDate,SQLVARCHAR,FALSE,FALSE,10)
or die("Could not send the date of the meeting to the procedure");
$Done=MSSQL_EXECUTE($Init)
or die("Couldn't update the database");
I keep getting the final "Couldn't update the database" message - I've tried running the procedure in SQL and it's having trouble converting from a VARCHAR to a date/time. I've tried all manner of CAST/CONVERT functions but with no success.
The stored proc. is (latest version!):
CREATE PROCEDURE UpdateMinutes
@Filename VARCHAR (50),
@MeetDate VARCHAR (10) --I assume this has to match the PHP
AS
INSERT INTO MeetMinutes (NameOfFile,MeetingDate)
VALUES ('@Filename',CAST ('@MeetDate' AS SMALLDATETIME))
GO
It's probably something fairly basic as I'm very new to this - any help gratefully received.
Last edited by AJPeck : December 9th, 2002 at 09:25 AM.
|
Dev Articles Community Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
