Re: FLASH: ASP for Dummy

[Helen Triolo]

james wrote:

> 

> > You're right about all of the above.  But CF tags

> > look like HTML tags.

> > ASP  resides inside of <% ... %> markers and doesn't

> > look like HTML.

> -----

> Ummm, If I recall, Cold Fusion tags are <# ... #>, so

> does that make it easier than <% ... %>

> 

Here is some Cold Fusion code, courtesy of Mark Zukiwsky:


<cfquery name="flashtext" datasource="MyDatabase" dbtype="OLEDB">

SELECT busUnit, unitName, novaUnit, activeUnit

FROM UnitTBL

WHERE SiteID = #Trim(FORM.SiteID)#

ORDER BY novaUnit, unitName

</cfquery>

<!--- Convert query results into list --->

<cfset unitList = valueList(flashtext.busUnit)>

<cfset nameList = valueList(flashtext.unitName)>

<cfset activeReturn = "">

<cfloop index = "unitIndex" from = "1" To = "#ListLen(unitList)#">

   <cfset tempUnit = ListGetAt(unitList, unitIndex)>

   <cfset unitX = "unit" & unitIndex>

   <cfoutput>&#unitX#=#tempUnit#</cfoutput>

   <cfoutput>&#unitNameX#=#URLEncodedFormat(tempName)#</cfoutput>

   <cfoutput>&#companyX#=#tempNova#</cfoutput>

   <cfoutput>&#activeX#=#tempActive#</cfoutput>

   <cfoutput>#chr(13)#</cfoutput>

</cfloop>

<cfoutput>&unitCount=#flashtext.recordCount##chr(13)#</cfoutput>

<cfoutput>&eof=1</cfoutput>


Here is some ASP code, courtesy of me:


<%

Set conn = Server.CreateObject("ADODB.Connection")

conn.open "iTechnica","",""

sql = "SELECT FlashAnswers.date, FlashAnswers.subject,

FlashAnswers.comment WHERE FlashAnswers.subject Like '%" &

Request.Form("searchstr") &  "%' ORDER BY FlashAnswers.subject"

set rs = Server.CreateObject("ADODB.Recordset")

rs.Open sql, conn, 3, 3

rs.MoveFirst

i=1

do while (i < CInt(Request.Form("startno")) and not rs.eof)

  rs.MoveNext

  i=i+1

loop

i=1

nfound = 0  bla bla bla

response.write finalstr

%>


My point was just that the former probably looks more familiar to an

HTML coder (and may therefore be a little easier to learn) than the

latter.  But you're right, the server platform certainly does matter

too.  One of the main reasons (if not *the* reason) I started with ASP

was because I could write and test it locally with PWS, which was 100%

free.


Regards,

Helen

__________________________________________________________________

i-Technica: Innovative Internet Solutions (http://i-Technica.com)

designeri-technica [dot] com

301-424-6037


flasher is generously supported by...

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

     flashforward2000 and The Flash Film Festival

  "The World�s Premier Flash Solutions Conference and Expo"

 March 27-29, Nob Hill Masonic Center, San Francisco, California


-Register before Feb 25 and save $200!!-- www.flashforward2000.com

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

To unsubscribe or change your list settings go to

http://www.chinwag.com/flasher or email

helpchinwag [dot] com