Isaac,
Here is the SQL:
CREATE SYNONYM TransServe
FOR [xx.xxx.xx.xxx].Snowline.dbo.Street
CREATE SYNONYM TransServeRoutes
FOR [xx.xxx.xx.xxx].Snowline.dbo.Route
SELECT Bus_Routes.Schedule_ID, Trans.RecordID, Trans.Prefix + ' ' + Trans.Name
+ ' ' + Trans.Type + ' ' + Trans.Suffix + '@' + ' ' + Trans1.Name + ' ' +Trans1
..Type + ' ' + Trans1.Suffix AS StreetName, Bus_Routes.Route_ID,
TransRoutes.VisibleRouteID
AS Route_Name, Schools.School_name, Bus_Routes.Side,
Bus_Routes.Pick_Up,Bus_Routes
..Drop_Off
FROM Bus_Routes
INNER JOIN TransServe Trans ON Bus_Routes.Main_St_ID = Trans.RecordID
INNER JOIN TransServe Trans1 ON Bus_Routes.X_Street_ID = Trans1.RecordID
INNER JOIN TransServeRoutes TransRoutes ON Bus_Routes.Route_ID = TransRoutes
..RecordID
INNER JOIN Schools ON Bus_Routes.School_ID = Schools.School_ID
WHERE (Bus_Routes.School_ID = @School_ID)
AND ModifiedSchedule = 0
ORDER BY Bus_Routes.Route_Name
DROP SYNONYM TransServe
DROP SYNONYM TransServeRoutes
And here is the function:
<cffunction name="getSchoolBusRoutes" access="public" returntype="query">
<cfargument name="School_ID" type="numeric" required="yes">
<cfset qSchoolBusRoute = "0">
<cfstoredproc procedure="pr_GetSchedulesRoutes"
datasource="#Request.dsn#">
<cfprocparam cfsqltype="cf_sql_integer"
dbvarname="School_ID" type="in" value="#Arguments.School_ID#">
<cfprocresult name="qSchoolBusRoute">
</cfstoredproc>
<cfreturn qSchoolBusRoute>
</cffunction>
and here I call the function
<cfinvoke
component="CFC.Transportation"
method="getSchoolBusRoutes"
returnvariable="getSchoolBusRoutesRet">
<cfinvokeargument name="School_ID" value="#School_ID#"/>
</cfinvoke>
On Dec 18, 2007 8:29 PM, s. isaac dealey <[EMAIL PROTECTED]> wrote:
>
> Thanks Bruce. I always figure when I'm replying after 6pm that there's a
> good chance there'll be that 12hr delay. :)
>
>
> --
> s. isaac dealey ^ new epoch
> isn't it time for a change?
> ph: 503.236.3691
>
> http://onTap.riaforge.org <http://ontap.riaforge.org/>
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:295101
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
