Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4

Thread: Chilisoft asp

  1. #1
    Senior Coder NancyJ's Avatar
    Join Date
    Feb 2005
    Location
    Bradford, UK
    Posts
    3,172
    Thanks
    19
    Thanked 65 Times in 64 Posts

    Chilisoft asp

    Does anyone here have experience working under a chilisoft asp environment?
    I work on IIS (at work) but I just tried to run one of my scripts on my own host that runs chilisoft and I'm having a hard time getting things working.

    My first problem was with regexp but I got that issue solved - it was merely a syntax difference (I think, dont know if the code works, but it compiles heh)

    The next problem I've come accrosss is .execute. I use this command a lot to execute sql queries. In the end I had to change them all to rs.open instead
    The problem I have now is I'm also using execute to create a string from an array of variable names eg.
    Code:
    execute("strCode = strCode&"&order(i))
    but i get this:
    Code:
    Microsoft VBScript runtime  error '800a000d'
    
    Type mismatch: 'execute'
    is there a different command in chilisoft to do what i'm doing because I cant get execute to work at all, even with basic strings.

  • #2
    Senior Coder Spudhead's Avatar
    Join Date
    Jun 2002
    Location
    London, UK
    Posts
    1,856
    Thanks
    8
    Thanked 110 Times in 109 Posts
    Sorry I'm confused - do you mean ADODBConnection.Execute ?

    If so, strCode should be a SQL statement (or stored proc name), it shouldn't be in quotes, and I'd do any string concatenation before you pass it into the function.

  • #3
    Senior Coder NancyJ's Avatar
    Join Date
    Feb 2005
    Location
    Bradford, UK
    Posts
    3,172
    Thanks
    19
    Thanked 65 Times in 64 Posts
    I've changed all my connection.execute statements to recordset.open sql, connection and they are working fine now.
    execute can also be used to execute a string as if it was a statement - eg.

    I want to do this
    Code:
    strCode = strCode & a
    where 'a' is a variable that contains a string
    however the names of the variables that I want to append to the string strCode are stored in an array order().
    so the execute command can be used to execute the string "strCode = strCode & a" as a statement.
    Code:
    execute("strCode = strCode&"&order(i))
    This works fine on IIS but not when working with chilisoft and I cannot find an alternative or a reason why the command would fail

  • #4
    Senior Coder NancyJ's Avatar
    Join Date
    Feb 2005
    Location
    Bradford, UK
    Posts
    3,172
    Thanks
    19
    Thanked 65 Times in 64 Posts
    sorry if I caused confusion with the conn.execute part of my post.
    I really just want to know what (if any) the alternative to execute is when using chillisoft asp rather than running on iis.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •