Found it!
I left a "&" inside my quotes here: ----------------------------¬
>>>>> --put "INSERT INTO norms " & "(" & tFields & ") & VALUES (:1, :2, :3, :4)"
<banging head against desk>
Thanks!
John Patten
SUSD
On Sep 30, 2011, at 12:09 PM, John Patten wrote:
> I checked the data that is being posted via the stack it looks correctly
> formatted.
>
> I then checked to see what the data would look like when it went through the
> first part of the irev code on the server, the: put $_POST["mymessage"] into
> mymessage
>
> When I ask the iRev/lc file to return mymessage it spits out: <pre>
> file"/home/xxxx/public_html/norms/enternormdata.lc@quot;</pre>
>
> Would that be what is expected? (As opposed to the URL formatted text
> submitted by the actual stack.)
>
> Thank you!
>
> John Patten
> SUSD
>
> On Sep 30, 2011, at 11:43 AM, John Patten wrote:
>
>> Hi Stephen...
>>
>> I tried it both ways. Originally it was .rev, but then with all the changes
>> I thought that may have been good for only existing code on the server so I
>> switched it to .lc
>>
>> It didn't help though :-(
>>
>>
>> In terms of the MySQl account and IP and cross-domain restrictions, that
>> would be relevant if I'm using the MySQl on the on-rev server too?
>>
>> Thank you!
>>
>> John Patten
>> SUSD
>>
>> On Sep 30, 2011, at 11:22 AM, stephen barncard wrote:
>>
>>> Also check your MySQL account for any IP or cross-domain restrictions.
>>>
>>> On 30 September 2011 11:20, stephen barncard <
>>> stephenrevoluti...@barncard.com> wrote:
>>>
>>>> how did you name the file? with a .lc or .rev suffix?
>>>>
>>>>
>>>> On 30 September 2011 11:12, John Patten <johnpat...@mac.com> 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
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>>
>>>>
>>>>
>>>> Stephen Barncard
>>>> San Francisco Ca. USA
>>>>
>>>> more about sqb <http://www.google.com/profiles/sbarncar>
>>>>
>>>>
>>>
>>>
>>> --
>>>
>>>
>>>
>>> Stephen Barncard
>>> San Francisco Ca. USA
>>>
>>> more about sqb <http://www.google.com/profiles/sbarncar>
>>> _______________________________________________
>>> 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
>
>
> _______________________________________________
> 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
