Any troubleshooting tips for figuring out why a query will run in SQL Query Analyzer but neverreturns when run through iBATIS?The query looks like this:INSERT INTO table_name1 (col1, col2, etc)SELECT col1, col2, etc.FROM table_name2The actual query is much more complicated than that. I'll include i
I assume that you meant something like
and
SELECT *
FROM my_table
WHERE my_column = #value# AND
my_date GETDATE()
I would choose the first example for readability. I don't think that
there are any performance implications.
Nathan
On Dec 9, 2005, at 12:34 PM, ooper wrote:
Just wond
What is the difference?
LArry
On 12/9/05, ooper <[EMAIL PROTECTED]> wrote:
> Just wondering if it matters how much of the query you include within the
> CDATA element?
>
> Is one of these preferable over the other? Why?
>
> SELECT *
> FROM my_table
> WHERE my_column = #value# AND
> my_date <= G
Just wondering if it matters how much of the query you include within the CDATA element?Is one of these preferable over the other? Why?SELECT *FROM my_tableWHERE my_column = #value# ANDTIA,Brian BarnettBroadband interface (RIA) + mail box saftey = http://iBatis_for_Java_Users_List.roomity.com*Your*
Sorry for the wierd format this is better:
select * from mytable where mytest ' '
Jeff Butler
On 12/9/05, Jeff Butler <[EMAIL PROTECTED]> wrote:
Put it in a cdata section like this:
select * from mytable where mytest ' 'Jeff Butler
On 12/9/05, Ashish Kulkarni <[EMAIL PROTECTED]
> wr
Use the CDATA construct, e.g.:
Ashish Kulkarni wrote:
Hi
I have a SQL statement as below, how do i define it in
xml
select * from mytable where mytest <> ' '
When i define it in xml file i get following error
The content beginning "<>" is not legal markup.
Perhaps the ">" (e;) cha
Put it in a cdata section like this:
select * from mytable where mytest ' 'Jeff Butler
On 12/9/05, Ashish Kulkarni <[EMAIL PROTECTED]> wrote:
HiI have a SQL statement as below, how do i define it inxmlselect * from mytable where mytest <> ' '
When i define it in xml file i get following errorT
What database are you using?
Why not use != ?
If you can then I would use < and >
Nathan
On Dec 9, 2005, at 11:01 AM, Ashish Kulkarni wrote:
Hi
I have a SQL statement as below, how do i define it in
xml
select * from mytable where mytest <> ' '
When i define it in xml file i get following
Hi
I have a SQL statement as below, how do i define it in
xml
select * from mytable where mytest <> ' '
When i define it in xml file i get following error
The content beginning "<>" is not legal markup.
Perhaps the ">" (e;) character should be a letter.
Ashish
___
Hi all,
I have the following class:
public class ObjectViewProperties {
private int aProperty;
private Map viewProperties;
}
where ViewType is an enum.
Now how do I create an sqlmap for this class?
(The enum itself is not the problem, I already have a typehandler for
enums.)
Great, that is really the better way to go.
Larry
On 12/8/05, Michael Laccetti [c] <[EMAIL PROTECTED]> wrote:
> Yeah, I just saw Eric's suggestion. That looks pretty good, I'm going to
> switch it to that tomorrow.
11 matches
Mail list logo
