Yes, wrap it all in a try/catch construct and then step through it to see which
line fails and why.
try
-- some code here
catch theError -- theError will contain detailed info on the error
answer theError as sheet
breakpoint -- so you can look at your variables here to see what they contain
end try
On Sep 30, 2011, at 11:12 AM, John Patten wrote:
> Hi All..
>
> I duplicated a script that is working to send data to on-rev mysql database
> in another project. The new project keeps throwing up a server connection
> error.
>
> I've tried to boil it down to the most basic components to trouble shoot, but
> I still get errors. I 'have looked for typos over and over but don't see
> anything. Here is what I have in its most basic form:
>
> <?lc
>
> put $_POST["mymessage"] into mymessage
> set itemDel to tab
>
> put item 1 of mymessage into tTargetPerson
> put item 2 of mymessage into tTargetNorm
> put itemDel into tCurrentItemDel
> set the itemDel to "|"
> put item 1 of tTargetNorm into tNorm_heading
> put item 2 of tTargetNorm into tNorm_topic
> set the itemDel to tab
> put item 3 of mymessage into tEventDescription
>
> put "localhost" into tDatabaseAddress
> put "xxxxxx_norms" into tDatabaseName
> put "xxxxxx_normuser" into tDatabaseuser
> put "xxxxxxx" into tDatabasePassword
>
> put tDatabaseAddress & " " & tDatabaseName & " " & tDatabaseuser & " " &
> tDatabasePassword into tResult
> --put revOpenDatabase("mysql", tDatabaseAddress, tDatabaseName,
> tDatabaseuser, tDatabasePassword) into tResult
> --if tResult is not a number then
> --put "Error: could not connect to database " & tResult
> --else
> --put "target_person, norm_heading, norm_topic, description" into tFields
> --put "INSERT INTO norms " & "(" & tFields & ") & VALUES (:1, :2, :3, :4)"
> into tSQL
> answer tResult
> --revExecuteSQL tResult, tSQL, "tTargetPerson", "tNorm_heading",
> "tNorm_topic", "tEventDescription"
> ?>
>
> I'm at the point now I'm just trying to see what the connection contents is
> in tResult, and it still throws up the server error???
>
> Any advice?
>
> Thank you!
>
> John Patten
> SUSD
>
> _______________________________________________
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
_______________________________________________
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
