Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot
 
PerlMonks  

Re^3: fetchall_arrayref hangs with placeholders query with no results

by perlfan (Vicar)
on Apr 15, 2021 at 17:57 UTC ( [id://11131342]=note: print w/replies, xml ) Need Help??


in reply to Re^2: fetchall_arrayref hangs with placeholders query with no results
in thread fetchall_arrayref hangs with placeholders query with no results

I'd be worried if it didn't produce the same result.

I was surprised to read this in DBD::Sybase, might be your client lib:

>DBD::Sybase supports the use of ? placeholders in SQL statements as long as the underlying library and database engine supports it. It does this by using what Sybase calls Dynamic SQL. The ? placeholders allow you to write something like: ...

Replies are listed 'Best First'.
Re^4: fetchall_arrayref hangs with placeholders query with no results
by Anonymous Monk on Apr 15, 2021 at 21:23 UTC
    When you use ? placeholders Sybase goes and creates a temporary stored procedure that corresponds to your SQL statement. You then pass variables to $sth->execute or $dbh->do, which get inserted in the query, and any rows are returned.

    So ... Sybase is obviously very different from the usual SQL standard ...

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://11131342]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others pondering the Monastery: (4)
As of 2024-03-29 00:51 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found