My Sql??

[keroed1]

@Owen yeah the user name and password is blank i never bother changing it

and thanks for the clarification, i have never used asp...i have used the later child asp.net

[MadHacker]

Zend Studio Link below
http://www.zend.com/products/zend_studio
have fun its a good tool but nothing beat old fashion notepad or notepad++

[keroed1]

i am trying to create a simple insert store procedure can someone tell me how to do that

[keroed1]

nobody got any ideas for me let me show u wat i was typing
BEGIN
AS INSERT INTO [JPSCO_DB].[dbo].[CustomerDetails]
( [CustomerId],
[BillDate],
[BillAmount])

VALUES
( @CustomerId,
@BillDate,
@BillAmount)
END

but i getting some error

or better this is there procedjure commands
CREATE PROCEDURE `insert_CustomerDetails`(@Customer INTEGER(11), @BillDate VARCHAR(20), @BilledAmount VARCHAR(20))
NOT DETERMINISTIC
SQL SECURITY DEFINER
COMMENT ''
BEGIN
AS INSERT INTO [JPSCO_DB].[dbo].[CustomerDetails]
( [CustomerId],
[BillDate],
[BillAmount])

VALUES
( @CustomerId,
@BillDate,
@BillAmount)
END;

[owen]

This is where you start reading;
http://dev.mysql.com/doc/refman/5.1/...re-syntax.html

stored procedures are a mysql version 5.1 feature

[keroed1]

This is where you start reading;
http://dev.mysql.com/doc/refman/5.1/...re-syntax.html

stored procedures are a mysql version 5.1 feature

thanks oweni going to go read it now

[MadHacker]

thanks oweni going to go read it now

lol Keroed1 dem bracket ting deh nuh really work inna mysql owen is pointing you in the right direction Oh yeah keroed1 please attempt to learn the basics before using gui (thats if you have the time)

[keroed1]

lol Keroed1 dem bracket ting deh nuh really work inna mysql owen is pointing you in the right direction Oh yeah keroed1 please attempt to learn the basics before using gui (thats if you have the time)

oh cool i thinking the same thing that i need to learn it at coman level, but i not too if i have the tiem since i have soo much things doing at the moment or maybe what i can do is learn to do some simple things in command line level, u know some simple store procedjures and so on

[keroed1]

i am trying to do a simple login store procedure that jus checks customer id # and password and returns the customerID# but teh storeprocedure evcen though it should that it fetched the row that has the corresponding id and password it showing the customer id that is suppose to be sent back as NULL

THIS IS THE CODE I TYPED
CREATE PROCEDURE `new_proc`(_AccountNumber INTEGER(4), _Password VARCHAR(50), OUT _CustomerID INTEGER(4))
DETERMINISTIC
SQL SECURITY DEFINER
COMMENT ''
BEGIN
SELECT _CustomerID=`cust_user_details`.`CustId`
FROM `cust_user_details`
WHERE
`cust_user_details`.`CustId`=_AccountNumber
AND
`cust_user_details`.`Pwd`= _Password;

END;

[keroed1]

anybody got any ideas? to why it returning null instead of the customerID