<cfquery> correct cfm-mysql/phpMyAdmin ? I use goDaddy.com hosting(php/cfml/mysql)

[123polis123]

[CODE]<cfquery datasource="cf123" password="1234CF123" username="cfdbK"
name="getData" >
SELECT * FROM CustomersTable
</cfquery>[/CODE]

is it correct if CustomersTable is a table in phpMyAdmin ? I am using
www.goDaddy.com hosting (php/cfml/mysql), well ?

[Adam Cameron]

Post by 123polis123
[CODE]<cfquery datasource="cf123" password="1234CF123" username="cfdbK"
name="getData" >
SELECT * FROM CustomersTable
</cfquery>[/CODE]
is it correct if CustomersTable is a table in phpMyAdmin ? I am using
www.goDaddy.com hosting (php/cfml/mysql), well ?

What is the question you're actually asking here?

[123polis123]

<cfquery > needs any other parameter ?

phpMyAdmin may be used with PHP or CFML , Correct ?

[Adam Cameron]

Post by 123polis123
<cfquery > needs any other parameter ?

I see. The code you wrote is syntactically correct from a CF POV, yes.
I'd think twice before passing the user/pwd in the <cfquery> though. Just
set it in CFAdmin if poss.

The docs are always a good place to refer to for this sort of info:
http://livedocs.adobe.com/coldfusion/8/htmldocs/Tags_p-q_17.html#1102316

Post by 123polis123
phpMyAdmin may be used with PHP or CFML , Correct ?

It depends what you mean. phpMyAdmin is a DB client written in PHP. So
you need PHP running to be able to run it. PHP can cohabitate with CF, so
this is not a problem.

IMO phpMyAdmin is less relevant now that MySQL has its own admin tools,
which run natively.
http://dev.mysql.com/downloads/gui-tools/5.0.html

I'd only want to run a web-based DB admin tool in emergencies or if there's
no other option.

[-==cfSearching==-]

Post by Adam Cameron
I'd think twice before passing the user/pwd in the <cfquery> though

You might also want to change the password if the one you posted above is your real password for your database ...

[Semaphorians]

Hi, I hope the below solves your concern:

First select the record from table using <cfquery> like

<cfquery name='selectqry' datasource='your_data_source_name'>
SELECT *
FROm table_name
WHERE your_condition

</cfquery>

then populate form items with this record like

<cfoutput query="selectqry">
<form >
<input type="text" name="textbox" value="#selectqry.column_name#" />
.
.
.
.
.
<input type="submit" name="submit" value="submit" />
</form>
</cfoutput>

Hope this helps!

[EnergyFed]

With GoDaddy.com they have PHP on all of their servers, and use phpMyAdmin.
Just remember when setting up a mySQL database that you will need to add a
coldfusion dns to the connection. This will add mysqlcf_ to your datasource
name.

Of course with GoDaddy, they do not allow access to the CFAdmin. This is why
it is important to add the CF Datasource when setting up a new mySQL database.

Then you will do all of your database work in phpMyAdmin.