how to connect to data source (newbie q)

[tektipforager]

I'm just starting to learn ColdFusion. I've installed the CF 9 free developers edition, with built-in web server, onto XP home edition. It's working OK - I can run basic code with simple tags.

I want to run a CFQUERY against an Oracle 10g express edition. I've added an Oracle data source which verified OK, but when I try a CFQUERY it has no effect - no errors, nothing.

Assuming the problem was with Oracle, I tried to cfquery against demo data that came with CF9 (cfdocexample on apache derby embedded) which also verifies OK. Same result - as if the cfquery is just ignored.

Is there some obvious step I've missed out?

 

[cfSearching]

If there was a problem with the datasource or SQL, you would probably be getting an error instead of "nothing". Stupid question, but is the code actually doing anything to display the results? ie Using CFDUMP or CFOUTPUT?

Try running this sample against the "cfdocexamples" database. The CFDUMP should show about 20+ records

<cfquery name = "GetSals" datasource = "cfdocexamples"> 
    SELECT * FROM Employee 
    ORDER BY LastName 
</cfquery>
<cfdump var="#GetSals#">

----------------------------------

http://cfsearching.blogspot.com/

 

[tektipforager]

Not a stupid question! there was no code to display the results!

Everything is working fine. (Well, cfdump works, so the only thing stopping me now is me....)

I'm amazed how easy it has been to set up the Oracle database and configure ColdFusion to use it as a datasource.

Thanks cfSearching

 

[cfSearching]

Yes, simplicity is one CF's strengths. Even some of the more complex stuff is much easier to achieve in CF than in other languages. At least IMHO ;-)

Anyway, glad I could help. If you have any other questions, just let us know!



----------------------------------

http://cfsearching.blogspot.com/

 

[kray4660]

I have always considered CF as HTML on steriods. It definately can make coding easier.