Stories
Slash Boxes
Comments

NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

use Perl

All the Perl that's Practical to Extract and Report

Apostrophe hell with SQL More | Login | Reply

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.

Without JavaScript enabled, you might want to use the classic discussion system instead. If you login, you can remember this preference.

Do all DBD's handle comments? (Score:1)

by dws (341) on 2003.01.31 0:10 (#16570) Homepage Journal

Are you trying to pass a comment through DBI? That's an iffy proposition. It's been my experience that database client tools do a bit of preprocessing before shipping SQL to the server, and part of that preprocessing is to strip comments.

Reply to This
- Re:Do all DBD's handle comments? (Score:2)
  
  by djberg96 (2603)
  
  I'm passing it to prepare(). The sql is stored in an external file, and I like to include comments so I remember what the point of the query was (in case I forget). Stripping the comments out is fine, but choking on them isn't. ;)
  - Re:Do all DBD's handle comments? (Score:1)
    
    by entropic (2521)
    
    DBD::Pg knows how to handle comments w/ an "'" in the comments
    
    there was a thread about rewriting DBD::Pg from scratch on the dbi list that discussed sql comments

Get More Comments

Stories, comments, journals, and other submissions on use Perl; are Copyright 1998-2006, their respective owners.