| Author |
Message
|
| wbader |
 Posted: Thu Feb 28, 2008 4:02 am Post subject: Select using IN (?,?,?) with different values per message |
 |
|
Newbie
Joined: 27 Feb 2008
Posts: 4
|
Hi,
I'm trying to SELECT number of rows from a database WHERE column IN (?,?,?). The number of values varies per Message. I tried doing something but i'm getting an error that says "'[DataDirect][ODBC Oracle driver]Value has not been specified for parameter 6.'"
Any Suggestions??!! |
|
| Back to top |
|
 |
| Gaya3 |
| Posted: Thu Feb 28, 2008 4:11 am Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
Hi
Did you try with the command PASSTHRU
Mods Plz move to MB Section, as it looks like an ESQL issue
Regards
Gayathri
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| Vitor |
| Posted: Thu Feb 28, 2008 4:20 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| Gaya3 wrote: |
| Mods Plz move to MB Section, as it looks like an ESQL issue |
Does rather. 
Moved.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| Vitor |
| Posted: Thu Feb 28, 2008 4:21 am Post subject: Re: Select using IN (?,?,?) with different values per messag |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| wbader wrote: |
| I tried doing something |
We might need just a hair more information before we can adequately diagnose the problem..... 
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| wbader |
| Posted: Thu Feb 28, 2008 5:07 am Post subject: |
|
|
Newbie
Joined: 27 Feb 2008
Posts: 4
|
| I'm trying to post my code, but i'm getting a message that says "no post mode specified"! |
|
| Back to top |
|
|
| Vitor |
| Posted: Thu Feb 28, 2008 5:46 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| wbader wrote: |
| I'm trying to post my code, but i'm getting a message that says "no post mode specified"! |
You might be a bit "new" to post code or links. Just tell us about it. 
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| wbader |
| Posted: Fri Feb 29, 2008 11:52 am Post subject: |
|
|
Newbie
Joined: 27 Feb 2008
Posts: 4
|
| I'd appreciate it if you guys would please tell me how can I post my code.. It'll be easier. |
|
| Back to top |
|
|
| Vitor |
| Posted: Fri Feb 29, 2008 1:44 pm Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| wbader wrote: |
| I'd appreciate it if you guys would please tell me how can I post my code.. It'll be easier. |
Never an administrator round when you need one, but I believe there's an anti-spammer feature on the board that prevents the posting of links until a given number of posts to stop the bots posting.
It was my theory that your failure to post was this or a similar feature. But I've nothing to back this theory, and no way round it except "post more".
If the problem persists, PM the admin.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| wbader |
| Posted: Mon Mar 03, 2008 11:21 pm Post subject: |
|
|
Newbie
Joined: 27 Feb 2008
Posts: 4
|
This is my my code:
SET PASS = 'SELECT * FROM ACVWS_ALL_AC_ENTRIES WHERE AC_NO IN (' || QUESTIONMARKS ||') AND STMT_DT = ?'
SET Environment.Variables.ACCTXN[] = PASSTHRU(PASS ,ALL_CHILD , '20070901')
PASSTHRU('COMMIT') |
|
| Back to top |
|
|
|
|
