Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Some advice please
Message
 
To
06/03/2002 13:21:53
James Blackburn
Qualty Design Systems, Inc.
Kuna, Idaho, United States
General information
Forum:
Visual FoxPro
Category:
Internet applications
Miscellaneous
Thread ID:
00628767
Message ID:
00629316
Views:
20
In a word, 'yes'.

What you do is establish an ODBC connection to the database. Then within the pages that you are accessing the dataase, you put cfml (that's coldfusion markup language) code to access and manipulate the data. For example:
<cfquery name="rsFullListing" 
    datasource=mydatasourcename
     username=myUserName 
	 password=myPassword>

SELECT last, first, office, phone, email FROM webventory ORDER BY LAST
</cfquery>
the above produces a record set which then is displayed using
<table>
<cfoutput query="rsFullListing"> 
    <tr bgcolor="lightgreen"> 
      <td>#rsFullListing.last#</td>
      <td>#rsFullListing.first#</td>
      <td>#rsFullListing.office#</td>
      <td>#rsFullListing.phone#</td>
      <td>#rsFullListing.email#</td>
    </tr>
</cfoutput> 
</table>
It gets a little ugly, but nothing that a old FoxPro coder can't deal with... :-)

>ColdFusion is one of the products I was looking at. I also looked some at ASP but that looked like it would be hard to manage in a large project. Does the data access part of ColdFusion have to be coded in the page like ASP?
>
-- Larry Keyes
Remember only You can prevent Gray Goo. Never release nanobot assembers without replication limiting code.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform