ColdFusion - Any other coders?

[DariusMonsef]

Didn't see ColdFusion listed as one of the discussion areas.

Any other ColdFusion programmers out there?

I've got a little experience with CF and I'd be happy to try and answer any questions.

Regards.

[my3brs]

okay thnx

[DariusMonsef]

was there a question? do you code CF?

[lostinbeta]

Ethan, great offer. I personally don't code CF, but occasionally (very rarely) a question gets asked here about it. Something like that goes in the Server-Side/Scripting section.

Unfortunately there is no where near enough people to create a section for it.

[DariusMonsef]

well maybe we could have "Kirupa" add a list of people and what they speciaqlize in, to aqct as some sort of resource for fellow members.

For Example, Me - Cold Fusion & SQL

[Digitalosophy]

Ethan, i recently started to code coldfusion. I woudl love to see some tutes, or even a section on Coldfusion and Flash Remoting. it's hard for me cuz I really don't knwo many peopel who use these techniques, so when I get stuck there is no help, and the help that is out there, is way too complex for a noob liek myself.

Hope to see more of you

[DariusMonsef]

I'm suprised more people here don't use CF as it is also a macromedia product. Anyway, post questions if you got them. I'll give it my best shot.

[ahmed]

hm.. can you give a sample script to connect to a mysql database? i would REALLY appreciate that :)

[Jubba]

I don't have a CF enabled server. :( Or I would use it.

[DariusMonsef]

ahmed,

Not sure exactly how to answer that. Do you mean the CF tag to query the mySQL, or the mySQL state ment to select something?

My expertise is in SQL Server and CF, but I'm gonna guess mySQL and SQL are similar.

Either way.

You should be able to query your DB with this:

<cfquery name="GetSomething" datasource="#Request.DataSource#" username="#Request.DataSourceLogin#" password="#Request.DataSourcePass#" dbname="#Request.dbname#">
SELECT * FROM MyTable
WHERE Something = Something
</cfquery>

You can hand code in the values for the CFQUERY tag but I usually jsut set them in the application file like:

<cfset Request.DataSource="Your Data Source Namae">
<cfset Request.DataSourceLogin="Login">
<cfset Request.DataSourcePass="Password">
<cfset Request.dbname="MyDBName">

You will also need to create the datasource and point it to the right database in your coldfusion server administrator area.

Regards.

[DariusMonsef]

Jubba,

Someone posted a CF question on the vector forum. Can you move it over?