Aloha, Pierre:
Thank you! there is nothing wrong with my SQL
If I use:
-------
put "INSERT INTO some-table (first_name, last_name, anonymous) VALUES
('Batman', 'MosquitoEater', TRUE);" into tSQL
revExecuteSQL gConnectionID,tSQL
put the result into tResponse
-------
I get '1' which is success
ergo: if my assumptions are correct, if you use revDataFromQuery for an
insertion and
query the result you will get an error.
which makes sense... the latter is getting data out, the former is
putting data in.
Problem solved, or rather, no problem at all except,
I was using the wrong rev dbase command for inserting data.
I guess I should probably study every single one of the revdb cmds in
the library.
Om shanti
Sivakatirswami
On 9/30/10 12:17 PM, Pierre Sahores wrote:
Have an eye on this about irev<=> postgreSQL production state design skills :
> put "SELECT module_name,activation FROM"&& CustModules&& "WHERE module_name =
'"& tparam1& "'" into sqlStatement
> put revQueryDatabase(myDatabaseID,sqlStatement) into
dbCursorID
> if dbCursorID is not a number
> then return the result
> else
>
> put
revDatabaseColumnNamed(dbCursorID,"activation") into nModuleState
> if nModuleState is in "NY" then
>
> if nModuleState is "Y"
> then put "N" into nModuleState
> else if nModuleState is "N"
> then put "Y" into nModuleState
> put "UPDATE"&& CustModules&& "SET activation = '"& nModuleState&
"' WHERE module_name = '"& tparam1& "'" into sqlStatement2
> revExecuteSQL myDatabaseID,sqlStatement2
> if the result is not a number
> then return the result
> else
> return "MODULE_"& nModuleState&
"_OK"
> end if
>
> else
>
> put "INSERT INTO"&& CustModules&& "(module_name,activation)
VALUES ('"& tparam1& "','Y')" into sqlStatement2
> revExecuteSQL myDatabaseID,sqlStatement2
> if the result is not a number
> then return the result # "error while
submitting the INSERT statement ..."
> else return "MODULE_UPDATE_OK"
>
> end if
>
> end if
each "then return the result" will expose the original postgreSQL error message
HTH,
P.
_______________________________________________
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
