Professional Web Applications Themes

placeholder error - PERL Modules

I am using DBD-Sybase 1.05-oc12.5.1. When running my script I get the following error: ct_result(ct_dynamic(CS_PREPARE)) returned -205 at //ms/dist/perl5/PROJ/DBD-Sybase/1.05-oc12.5.1-5.8/lib/perl5/DBD/Sybase.pm line 150, <DATA> line 283. I believe the error lies within this line: $DBH->prepare("UPDATE $table_name SET $del_col = $del_val WHERE $user_col = ?") I know you can't use the prepare() call with placeholders. My problem is that I don't know what to use instead of the placeholder. If anyone would help me out, I would greatly appreciate it. Thank You, Natalie...

  1. #1

    Default placeholder error

    I am using DBD-Sybase 1.05-oc12.5.1. When running my script I get the
    following error:

    ct_result(ct_dynamic(CS_PREPARE)) returned -205 at
    //ms/dist/perl5/PROJ/DBD-Sybase/1.05-oc12.5.1-5.8/lib/perl5/DBD/Sybase.pm
    line 150, <DATA> line 283.

    I believe the error lies within this line:

    $DBH->prepare("UPDATE $table_name SET $del_col = $del_val WHERE
    $user_col = ?")

    I know you can't use the prepare() call with placeholders. My problem
    is that I don't know what to use instead of the placeholder. If anyone
    would help me out, I would greatly appreciate it.

    Thank You,
    Natalie

    lnatz Guest

  2. #2

    Default Re: placeholder error

    lnatz wrote:
    > I am using DBD-Sybase 1.05-oc12.5.1. When running my script I get the
    > following error:
    >
    > ct_result(ct_dynamic(CS_PREPARE)) returned -205 at
    > //ms/dist/perl5/PROJ/DBD-Sybase/1.05-oc12.5.1-5.8/lib/perl5/DBD/Sybase.pm
    > line 150, <DATA> line 283.
    >
    > I believe the error lies within this line:
    >
    > $DBH->prepare("UPDATE $table_name SET $del_col = $del_val WHERE
    > $user_col = ?")
    >
    What makes you think that? I mean, for all I know, you're right, but
    nothing about that error message points to a specific line of your
    code. Did you look up the Sybase doentation to see what -205 means?
    > I know you can't use the prepare() call with placeholders.
    Huh?
    > My problem
    > is that I don't know what to use instead of the placeholder. If anyone
    > would help me out, I would greatly appreciate it.
    I don't know where you got the idea that you can't use placeholders in
    a prepare()'d statement. On the contrary, that's one of the primary
    reasons for using prepare (followed by multiple executes) rather than a
    simple do()...

    Paul Lalli

    Paul Lalli Guest

Similar Threads

  1. Usercontorl in a placeholder
    By Pradeep in forum ASP.NET Building Controls
    Replies: 1
    Last Post: November 3rd, 11:34 PM
  2. Automatic Date Placeholder
    By psychpower in forum Macromedia Contribute General Discussion
    Replies: 1
    Last Post: May 5th, 02:15 PM
  3. Build control in a placeholder or like a placeholder
    By nail in forum ASP.NET Building Controls
    Replies: 0
    Last Post: September 10th, 07:57 PM
  4. 4GL V7.31 placeholder problem?
    By Malc P in forum Informix
    Replies: 8
    Last Post: October 19th, 11:12 PM
  5. Placeholder Question
    By trinitypete in forum ASP.NET General
    Replies: 2
    Last Post: July 1st, 12:42 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139