Click here to Skip to main content
15,900,524 members
Home / Discussions / Database
   

Database

 
GeneralRe: SQL Server 2000 mirror Database Pin
Colin Angus Mackay27-Jun-07 12:19
Colin Angus Mackay27-Jun-07 12:19 
GeneralRe: SQL Server 2000 mirror Database Pin
Mike Dimmick27-Jun-07 23:30
Mike Dimmick27-Jun-07 23:30 
QuestionStored procedure Pin
sidbaruah26-Jun-07 23:36
sidbaruah26-Jun-07 23:36 
AnswerRe: Stored procedure Pin
mamatha_raghu27-Jun-07 0:17
mamatha_raghu27-Jun-07 0:17 
AnswerRe: Stored procedure Pin
Pratik Vasant Shah27-Jun-07 19:44
Pratik Vasant Shah27-Jun-07 19:44 
Questionmysql input with stored procedure help Pin
boyindie26-Jun-07 23:20
boyindie26-Jun-07 23:20 
AnswerRe: mysql input with stored procedure help Pin
Devkranth Kishore Vanja28-Jun-07 20:42
Devkranth Kishore Vanja28-Jun-07 20:42 
GeneralRe: mysql input with stored procedure help Pin
boyindie28-Jun-07 21:48
boyindie28-Jun-07 21:48 
cheers for help but i solved the issue

just in case you have lost sleep over it the problem was

the stored procedure in mySql doesn't support the @ for parameters so u declare the procedure like this

Create procedure sp_insert(IN p_firstName varchar(20), IN p_lastName varchar(20)
AS
BEGIN
INSERT
END

Need to declare them as input parameters

But the reason it wasn't insert as when ur passing the parameters into the procedure from asp you need to provide ? as the prefix, as this is mySQLs prefix.

So its done parameter.add("?p_firstname".........

Thanks

boyind
Questionsharing sql server without client installation Pin
mamatha_raghu26-Jun-07 20:41
mamatha_raghu26-Jun-07 20:41 
AnswerRe: sharing sql server without client installation Pin
Manas Bhardwaj26-Jun-07 22:24
professionalManas Bhardwaj26-Jun-07 22:24 
AnswerRe: sharing sql server without client installation Pin
originSH26-Jun-07 22:29
originSH26-Jun-07 22:29 
GeneralRe: sharing sql server without client installation Pin
mamatha_raghu27-Jun-07 0:06
mamatha_raghu27-Jun-07 0:06 
GeneralRe: sharing sql server without client installation Pin
originSH27-Jun-07 1:06
originSH27-Jun-07 1:06 
AnswerRe: sharing sql server without client installation Pin
Mike Dimmick27-Jun-07 2:46
Mike Dimmick27-Jun-07 2:46 
QuestionSequence of events/methods execuion in SSIS Pin
I.explore.code26-Jun-07 19:57
I.explore.code26-Jun-07 19:57 
Questionpull subscriptions Pin
SVb.net26-Jun-07 12:58
SVb.net26-Jun-07 12:58 
QuestionDatabase design for exam system? Pin
HinJinShah26-Jun-07 8:08
HinJinShah26-Jun-07 8:08 
AnswerRe: Database design for exam system? Pin
Ashiq Shaikh26-Jun-07 22:56
professionalAshiq Shaikh26-Jun-07 22:56 
GeneralRe: Database design for exam system? Pin
HinJinShah27-Jun-07 6:31
HinJinShah27-Jun-07 6:31 
QuestionProblem configuring an OldDbDataAdaptor in VS03 Pin
Dan Neely26-Jun-07 4:54
Dan Neely26-Jun-07 4:54 
AnswerRe: Problem configuring an OldDbDataAdaptor in VS03 Pin
Dan Neely26-Jun-07 6:58
Dan Neely26-Jun-07 6:58 
AnswerRe: Problem configuring an OldDbDataAdaptor in VS03 Pin
hisi_200526-Jun-07 16:50
hisi_200526-Jun-07 16:50 
QuestionCalling all Irish devs!! Region-specific characters Pin
Mel Padden26-Jun-07 4:48
Mel Padden26-Jun-07 4:48 
AnswerRe: Calling all Irish devs!! Region-specific characters Pin
Mike Dimmick27-Jun-07 3:10
Mike Dimmick27-Jun-07 3:10 
QuestionMS Access functions to Oracle Pin
Mangilipelli26-Jun-07 2:20
Mangilipelli26-Jun-07 2:20 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.