Writing to DB from a Projector

[TheConeHead]

Is it possible to fire off a page (like an asp page) that needs to be processed from a projector?

 

[billwatson]

I didnt write this...its an answer I saved one time in case i ever have to deal with this situation so i cant say how well it works.


................

ASP sample

First of all create a txt name input text and add it into your server. where
you can find or view it as:
EX:

http://www.NAME.com/input.txt

I'm going to give you 2 types of ASP
see if which one work for you :

Type #1:

'--------copy below-------
<%
Dim objFSO, objTextFile,thetext ' Declare variables for the File System
Object and the File to be accessed.
thetext=request.form(&quot;thetext&quot ' Request the text you wanted to save
Set objFSO = CreateObject(&quot;Scripting.FileSystemObject&quot ' Create an instance
of the the File System Object and assign it to objFSO.
Set objTextFile = objFSO.CreateTextFile(&quot;

http://www.NAME.com/input.txt&quot;)

objTextFile.WriteLine &quot;thetext=&quot; & thetext ' Write in the input.txt.
objTextFile.Close ' Close the file.
Set objTextFile = Nothing ' Release reference to the text file.
Set objFSO = Nothing ' Release reference to the File System Object.
%>
'---------stop here-----------

Type#2
'---------start here----------

<%
Dim objFSO, objTextFile,thetext ' Declare variables for the File System
Object and the File to be accessed.
thetext=request.form(&quot;thetext&quot ' Request the text you wanted to save
Set objFSO = CreateObject(&quot;Scripting.FileSystemObject&quot ' Create an instance
of the the File System Object and assign it to objFSO.

Set objTextFile = objFSO.CreateTextFile(Server.MapPath(&quot;input.txt&quot) ' Open
the file
objTextFile.WriteLine &quot;thetext=&quot; & thetext ' Write in the textfile.txt.
objTextFile.Close ' Close the file.
Set objTextFile = Nothing ' Release reference to the text file.
Set objFSO = Nothing ' Release reference to the File System Object.
%>

'-------stop here-------

Make sure your server Support ASP.
make sure.. all files are in same dirctory (SWF/ASP/TXT)

Last will the action from flash
loadVariables (&quot;

http://www.NAME.com/savetext.asp&quot;,

&quot;/&quot;, &quot;POST&quot;

and you all set .

 

[oldnewbie]

Bill you should really learn how to use the &quot;code&quot; tags, when posting code with urls for instance, it would avoid the confusion that may be created with the added &quot;;&quot; at the end of your urls, if you don't.

Regards,

 

[TheConeHead]

wow - I got it figured out - my code was not that long though.... I just did loadVariablesNum (&quot;

http://....&quot;,

0, &quot;Post&quot;

The part I was getting stuck on was loadVariablesNum (&quot;record.asp&quot;....

and doing it like that was not running it through the web server because it was a projector.... but since I did as in my first example (putting the whole URL) it runs it through the web server and works great....