Prev: Transposing X and Y coord from child to parent
Next: FAQ Topic - How do I POST a form to a new window? (2010-04-29)
From: Rob Christiansen on 28 Apr 2010 18:03
Thankyou for your help. OK, here's my try, and the results I get:
SQL = "UPDATE books1 SET debit = CONVERT(currency(8),"+
rs("debit").Value +")";
Response.Write( "SQL = "+ SQL +"<br>" );
ConnectionObject.Execute( SQL );
--------------------------------
SQL = UPDATE books1 SET debit = CONVERT(currency(8),107.36) <-- Could I
specify ". . . WHERE id = 1088?"
Microsoft JET Database Engine error '80040e14'
Undefined function 'CONVERT' in expression.
/books/convertbooks.asp, line 72

crazyswede

*** Sent via Developersdex http://www.developersdex.com ***
From: Sean Kinsey on 28 Apr 2010 18:12
On Apr 29, 12:03 am, Rob Christiansen <robb_christian...(a)q.com> wrote:
> Thankyou for your help. OK, here's my try, and the results I get:
> SQL = "UPDATE books1 SET debit = CONVERT(currency(8),"+
> rs("debit").Value +")";    
> Response.Write( "SQL = "+ SQL +"<br>" );  
> ConnectionObject.Execute( SQL );  
> --------------------------------
> SQL = UPDATE books1 SET debit = CONVERT(currency(8),107.36) <-- Could I
> specify ". . . WHERE id = 1088?"
> Microsoft JET Database Engine error '80040e14'
> Undefined function 'CONVERT' in expression.
> /books/convertbooks.asp, line 72

Seriously, have you even tried searching for this? The following
keywords comes to mind 'sql, convert, jet, 80040e14'...
And why are you converting in the first place, have you even tried
setting the value as is?
 | 
Pages: 1
Prev: Transposing X and Y coord from child to parent
Next: FAQ Topic - How do I POST a form to a new window? (2010-04-29)