Incorrect SQL query in perl Post: 302070313

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

& in SQL query

I have a script that looks for all jobs that contain a particular calendar. Some of the calendars have '&' in them and sql freaks out when it encounters that.. is there a way around this? I have tried: select job_name from job where run_calendar='1&15dom' select job_name from job...

2. Shell Programming and Scripting

Need help in printing a sql query in perl

Hi All, I have the following sql query select abcd from udbadm.log where xyz='1'. I have 16k queries similar to this with different values for xyz. I want to print the values of 'abcd' for each row. I have the following perl code, but not sure how i can print that particular...

3. Shell Programming and Scripting

How to use sql data file in unix csv file as input to an sql query from shell

Hi , I used the below script to get the sql data into csv file using unix scripting. I m getting the output into an output file but the output file is not displayed in a separe columns . #!/bin/ksh export FILE_PATH=/maav/home/xyz/abc/ rm $FILE_PATH/sample.csv sqlplus -s...

4. UNIX for Advanced & Expert Users

Passing Hash variable in to sql query in perl

Hi Everyone, Can anyone help me how do i call hash variable in to sql query in perl. Please see the script below i have defined two Hash %lc and %tab as below $lc{'REFF'}='V_RES_CLASS'; $lc{'CALE'}='V_CAP_CLASS'; $lc{'XRPD'}='V_XFMR_CLASS'; $tab{'V_RES_CLASS'}='V_MFR_SERS';...

5. Shell Programming and Scripting

run sql query via perl script

Hello, If I run this command on the server it works. # dbc "update config set radio_enabled = 0;" how can I execute the same command in perl. I have defined the dbc path. Can any one please correct the last line. #!/usr/bin/perl #database path $dbc='/opt/bin/psql -Userver...

6. Shell Programming and Scripting

create sql query

7. Shell Programming and Scripting

perl- oracle sql query

Hi, I am new to perl.How to query oracle database with perl??? Thanks

8. Shell Programming and Scripting

problem in SQL query

I used the following code code select * from tablename where columnname Instead of printing the expected output it prints all the files in the present directory since there is a "*" in the code. Is there any way to overcome the problem? Thanks Ananth

9. Shell Programming and Scripting

Run SQL thru shell script: how to get a new line when run sql query?

Hi, this's Pom. I'm quite a new one for shell script but I have to do sql on shell script to query some information from database. I found a concern to get a new line...When I run my script, it retrieves all data as wondering but it's shown in one line :( What should I do? I'm not sure that...

10. Programming

Help writing SQL query

Hello All, I hope I'm posting this in the right section. I have zero sql query writing skill, in fact, I've never done it before, but for some reason, a request came across my desk to get information from one of our databases. I have about 200 ticket numbers that have no information attached,...

LEARN ABOUT DEBIAN

cs_register_esc_strfunc

cs_register_esc_strfunc(3)					      cs/cs.h						cs_register_esc_strfunc(3)

NAME

       cs_register_esc_strfunc	- cs_register_strfunc with escaping context

SYNOPSIS

       #include <cs/cs.h>

       NEOERR *cs_register_esc_strfunc(CSPARSE *parse, char *funcname,
				       CSSTRFUNC str_func);

ARGUMENTS

       parse - a pointer to a CSPARSE structure initialized with cs_init()
       funcname - the name for the CS function call
       Note that registering a duplicate funcname will
       raise a NERR_DUPLICATE error
       str_func - a CSSTRFUNC not-callback

DESCRIPTION

       cs_register_esc_strfunc	functions exactly as cs_register_strfunc except that it changes the evaluation escaping context to disable default
       escaping.

SEE ALSO

       cs_dump(3), cs_destroy(3),  cs_render(3),  cs_register_esc_strfunc(3),  cs_arg_parsev(3),  cs_register_fileload(3),  cs_init(3),  cs_regis-
       ter_strfunc(3), cs_arg_parse(3), cs_parse_string(3), cs_parse_file(3), =(3), cs_register_function

ClearSilver							   12 July 2007 					cs_register_esc_strfunc(3)