i think i found it:
____________________________________
<cfset CurrentPage=GetFileFromPath(GetBaseTemplatePath())>
<cfparam name="PageNum_rs_christmas" default="1">
<cfquery name="rs_christmas" datasource="spaceexpressions">
SELECT *
FROM christmasphotos
ORDER BY photo_id ASC
</cfquery>
<cfset MaxRows_rs_christmas=5>
<cfset
StartRow_rs_christmas=Min((PageNum_rs_christmas-1)*MaxRows_rs_christmas+1,Max(rs_christmas.RecordCount,1))>
<cfset
EndRow_rs_christmas=Min(StartRow_rs_christmas+MaxRows_rs_christmas-1,rs_christmas.RecordCount)>
<cfset
TotalPages_rs_christmas=Ceiling(rs_christmas.RecordCount/MaxRows_rs_christmas)>
<cfset QueryString_rs_christmas=Iif(CGI.QUERY_STRING NEQ
"",DE("&"&XMLFormat(CGI.QUERY_STRING)),DE(""))>
<cfset
tempPos=ListContainsNoCase(QueryString_rs_christmas,"PageNum_rs_christmas=","&")>
<cfif tempPos NEQ 0>
<cfset
QueryString_rs_christmas=ListDeleteAt(QueryString_rs_christmas,tempPos,"&")>
</cfif>
____________________________________________
i replaced the datasource with the string i got from godaddy
(p50mysql113.secureserver.net), but it still doesn't work. i guess i am
learning more everyday. please say something.
daniel
>Daniel,
>You need to place the DSN string (Datasource name as defined in the CF
>administrator by godaddy) in the CFQUERY tag (that you did not show in your
>code sample).
>
>Ex:
>
><cfquery name=" rs_christmas " datasource="DSN_STRING_HERE">
> SELECT * FROM FOO
></cfquery>
>
>
>HTH,
>Rich
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300950
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
