Flasher Archive

[Previous] [Next] - [Index] [Thread Index] - [Previous in Thread] [Next in Thread]


Subject: Re: FLASH: ASP for Dummy
From: Helen Triolo
Date: Fri, 31 Mar 2000 15:55:52 +0100

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)
designerati-technica [dot] com
301-424-6037

flasher is generously supported by...
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
flashforward2000 and The Flash Film Festival
"The Worlds 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 helpatchinwag [dot] com


Replies
  Re: FLASH: ASP for Dummy, james

[Previous] [Next] - [Index] [Thread Index] - [Next in Thread] [Previous in Thread]