Slightly OT if this is more about PostGreSQL than LiveCodeServer
I'm doing my very first dbase insertion from an iRev form. finally getting
a successful a connection ID after fiddling with pg_hba.conf
ASIDE: does RevServer connect on local unix domain socket or local tcp/ip
Then tried this (a
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) int
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 succ