May 25, 2010 at 2:23 am
this:
SelectCommand="SELECT [Previous Amount] AS Previous_Amount FROM [pensions]">
works perfectly fine.
this:
SelectCommand="SELECT [Previous Amount]* " & March_cpi_factor_session & " AS Previous_Amount FROM [pensions]">
does not.
The second version attempts to multiply a value in the database by a session variable value. However, trying to use it results in errors like 'the server tag is not well formed' or 'syntax error in . . .' depending upon how I fiddle about with the syntax. The session variable is OK - it is used elsewhere and has no problems. Does anyone know where this is falling over OR can anyone suggest an alternative approach to this operation? Thanks.
May 25, 2010 at 8:35 am
If you print out the string instead of submitting it as a query, what is shown for the second value? The multiplication looks good at first glance.
May 27, 2010 at 2:25 am
the problem is with the session variable. Disturbingly, I've spent the last couple of days looking for similar problems (and, hopefully) solutions on the 'net. There are very few similar problems in forums, and none of the solutions to those specific problems work. What i find particularly disheartening is that there doesn't seem to be a single (or, for that matter, any) resource that describes how this type of thing should be coded. :((((((((((
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply