@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
@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
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++
i am trying to create a simple insert store procedure can someone tell me how to do that
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;
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
Check out My Awesome Blog & News Jamaica
thanks oweni going to go read it nowOriginally Posted by owen
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)Originally Posted by keroed1
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 onOriginally Posted by MadHacker
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;
anybody got any ideas? to why it returning null instead of the customerID