Forum Replies Created

Viewing 7 posts - 1 through 7 (of 7 total)

  • RE: Using stored procedures in ASP(vbscript)

    you've earned my gratitude!

    thx a lot for the help!

    -

    Signature? I don't need no stinking signature!

  • RE: Using stored procedures in ASP(vbscript)

    yeah sure, the full code atm(ripped heavily for debugging purposes) is:

    
    

    strConn = "Provider=SQLOLEDB; Data Source=SERVER; Initial Catalog=PortalSQL; User Id=UID; Password=PWD"

    ...[bits n' pieces]...

    dim cnCmd
    set cnCmd =...
  • RE: Using stored procedures in ASP(vbscript)

    tried that, now I've got:

    ...

    ...("@new_member_mail", adWChar, adParamOutput, 20)

    and then

    ... response.write cnCmd("@new_member_email")

    and I get, nowt, no errors, no values passed...

    -

    Signature? I don't need no stinking signature!

    Edited by - dna on...

  • RE: Using stored procedures in ASP(vbscript)

    Still lost here, I've reworked the initial SP with:

    
    
    [declare sp etc...]
    @new_member_first_name nvarchar(20) OUTPUT,
    @new_member_last_name nvarchar(20) OUTPUT,
    @new_member_login nvarchar(15) OUTPUT,
    @new_member_password...
  • RE: Using stored procedures in ASP(vbscript)

    Aye, I think ur final solution was really what I was looking for, I just couldn't figure out the syntax of it, been trying various stuff in that vicinity but...

  • RE: Using stored procedures in ASP(vbscript)

    Maybe I am not clear enough?

    The values(new_members.first_name, new_members.last_name, new_members.login, new_members.password and new_members.email)

    inserted from [new_members] into [members]

    Is what I really want to be able to return to my application, is...

  • RE: Using stored procedures in ASP(vbscript)

    Right, so I have to do a serperate select statement, I was kinda hoping I could just pass the data from the first.. hrm, oh well, it may just be...

Viewing 7 posts - 1 through 7 (of 7 total)