Ask a Question related to Coldfusion Database Access, Design and Development.
-
pearl_honey #1
database access
hai~ why when i run my coding, it shows error executing database query. so, wut's the prob actually?? n actually i'm still new wif coldfusion n in a learning process.so can someone help me?tq
pearl_honey Guest
-
Access Database
Hello. We have a database that we does like to use in a movie. How can we do that? Need any special Xtra? Thanks for help Paul and Mike -
access to database
hi to everybody. i'm a newbie in the world of mysql and i've got a problem with the access to a database. i created a user 'default', from host %,... -
.NET Database access
post the connection script with the full path to the database. also since your site is probably not on the root of the drive make sure you are... -
Web access to database
Hi. I've built a quite complicated database for tracking clients, projects, logging work, etcetera for my company, over the last few years. Now... -
Write Access to Access DataBase
I'm trying to update a Access Database from information gained from a ASPX page. The database will not update. I'm sure it is in some security... -
Neculai Macarie #2
Re: database access
> hai~ why when i run my coding, it shows error executing database query.
so, wut's the prob actually?? n actually i'm still new wif coldfusion n in a
learning process.so can someone help me?tq
You need to give us the error that is displayed and the cf code around the
place where the error occurs.
--
<mack />
Neculai Macarie Guest
-
-
pearl_honey #4
Re: database access
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
-------------
This is the coding :
<body>
<cfquery name="borang" datasource="db1.mdb">
SELECT Pegawai.Firstname, Pegawai.Lastname,Pegawai.NoStaff, Pegawai.Gred,
Pegawai.Position, Pegawai.Address, Pegawai.phone1, Pegawai.phone2
FROM Pegawai
</cfquery>
<cfoutput query="pegawai">
<p>#form.FirstName#</p>
<p>#form.LastName# </p>
<p>#form.NoStaff#</p>
<p>#form.Gred#</p>
<p>#form.Position#</p>
<p>#form.Address#</p>
<p>#form.phone1#</p>
<p>#form.phone2#</p>
</cfoutput>
</body>
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--
is it the prob coming from the coding or from my database?
+thanks 4 helping+
pearl_honey Guest
-
The ScareCrow #5
Re: database access
The name of the query you want to output is borang
so change the following
<cfoutput query="pegawai">
to
<cfoutput query="borang">
Ken
The ScareCrow Guest
-
pearl_honey #6
Re: database access
i knoe nothing bout cfml..but i want to try to develope 1 system wif cfml.so,
i'm still in a learning process...i want to know how to create a form.which is
when i fill the form all the data will go into the database n i can view the
data back. tq..
pearl_honey Guest
-
redriver0219 #7
Database Access
I've installed MySQL 5.022 with ColdFusion MX7 using the driver
mysql-connector-java-3.1.13 (from MySQL.com). I'm getting a message in
DreamWeaver that certain MySQL datatypes aren't recognized (specifically
interger and mediuminteger). I'm using the driver recommended by Macromedia
technicians to get around a problem with the 3.1.11 MySQL driver. I noticed
that a MySQL 5.0 driver is in development, but I don't want to use it until
it's stable.
Does anyone have any advice on how I can fix this?
redriver0219 Guest



Reply With Quote

