How to use 'ampersand' in sql-update tag in Jameleon script?

View: New views
2 Messages — Rating Filter:   Alert me  

How to use 'ampersand' in sql-update tag in Jameleon script?

by Satish Ingle :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi All,

I want to insert/update records in one of my table with ampersand ('&') sign. I am using 'sql-update' tag to do this. My query is as follows:
update cust set custname = 'JO & JO SONS' where custno = 12345

I am using Eclipse to run the script but it gives me the error that 'The entity name must immediately follow the '&&;' in the entity reference. When I execute the script it gives error 'Could Not parse Jelly script'.

What could be done to solve the problem?

Thanks in advance to all.

Bye,

Satish

Re: How to use 'ampersand' in sql-update tag in Jameleon script?

by jameleon-users mailing list :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message


try either putting that value in a properties file or escaping the & with &





----- Original Message ----
From: "jameleon-users@..." <jameleon-users@...>
To: jameleon-users@...
Sent: Sunday, July 12, 2009 11:02:08 PM
Subject: [Jameleon-users] How to use 'ampersand' in sql-update tag in Jameleon script?


Hi All,

I want to insert/update records in one of my table with ampersand ('&')
sign. I am using 'sql-update' tag to do this. My query is as follows:
update cust set custname = 'JO & JO SONS' where custno = 12345

I am using Eclipse to run the script but it gives me the error that 'The
entity name must immediately follow the '&&;' in the entity reference. When
I execute the script it gives error 'Could Not parse Jelly script'.

What could be done to solve the problem?

Thanks in advance to all.

Bye,

Satish

--
View this message in context: http://www.nabble.com/How-to-use-%27ampersand%27-in-sql-update-tag-in-Jameleon-script--tp24386550p24386550.html
Sent from the jameleon-users mailing list archive at Nabble.com.


------------------------------------------------------------------------------
Enter the BlackBerry Developer Challenge  
This is your chance to win up to $100,000 in prizes! For a limited time,
vendors submitting new applications to BlackBerry App World(TM) will have
the opportunity to enter the BlackBerry Developer Challenge. See full prize  
details at: http://p.sf.net/sfu/Challenge
_______________________________________________
Jameleon-users mailing list
Jameleon-users@...
https://lists.sourceforge.net/lists/listinfo/jameleon-users



     

------------------------------------------------------------------------------
Enter the BlackBerry Developer Challenge  
This is your chance to win up to $100,000 in prizes! For a limited time,
vendors submitting new applications to BlackBerry App World(TM) will have
the opportunity to enter the BlackBerry Developer Challenge. See full prize  
details at: http://p.sf.net/sfu/Challenge
_______________________________________________
Jameleon-users mailing list
Jameleon-users@...
https://lists.sourceforge.net/lists/listinfo/jameleon-users