with postgres - ColdFusion

53 New Member

anybody pls help me with my coldfusion!!!

my code for selecting records from database is:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>

<body>

<cfoutput > testss </cfoutput><br />

<cfquery name="name" datasource="ubill">
Select * from name
</cfquery>

<CFOUTPUT QUERY="name">

<tr>

<td width="50%" align="center"><input type="text" name="name" size="40" value="#name.name#" ></td><br />

<td width="50%" align="center"><input type="text" name="address" size="40" value="#name.address#" ></td>

</tr>

</CFOUTPUT>
</body>
</html>

above code worked well . but when i use above code for inserting as:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>

<body>

<cfoutput > testss </cfoutput><br />

<CFOUTPUT QUERY="name">

<tr>

<td width="50%" align="center"><input type="text" name="name" size="40" value="#name.name#" ></td><br />

<td width="50%" align="center"><input type="text" name="address" size="40" value="#name.address#" ></td>

</tr>

</CFOUTPUT>

<cfquery name="name" datasource="ubill">
INSERT
INTO name
(name,address)
VALUES
('#name.name#','#name.address#')
</cfquery>

</body>
</html>

but this code didn't worked.what may be the right code?

plz help me!!!

Apr 30 '07 #1

Subscribe Reply

2062

acoder

16,027

Recognized Expert Moderator MVP

You need to put the insert code before you output the query as you have done when selecting the records.

Apr 30 '07 #2

Similar topics

postgres crashes

by: Adam Kempa | last post by:

Hello I've been installed Postgres 7.4.2 on FreeBSD system and when load average grow up i've error in postgres like this: ERROR: permission denied for function varchar ERROR: permission...

PostgreSQL Database

Connecting to postgres from a romote machhine

by: N.K. | last post by:

Hi, I've just installed postgres on the Linux server. It is supposed to start automatically which I think it does since I can run an sql stmt right away. When I'm trying to connect from a remote...

PostgreSQL Database

Error on initdb with 7.4RC2

by: Martin Marques | last post by:

When running initdb on a fresh 7.4 install I get this error: postgres@bugs:~$ /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data -E latin1 The files belonging to this database system will be...

PostgreSQL Database

C Programming with postgres.h - my function crashes the database backend

by: Alex Page | last post by:

I've been trying to extend Postgres and create an enumerated type to represent gender, as a precursor to more complex enumerated types. I've created the C functions for input and output with the...

PostgreSQL Database

Postgres filling up hard drive with swap files

by: Joe Lester | last post by:

This thread was renamed. It used to be: "shared_buffers Question". The old thread kind of died out. I'm hoping to get some more direction by rephrasing the problem, along with some extra...

PostgreSQL Database

postgres.h location?

by: Scott Frankel | last post by:

I'm looking for the file postgres.h in my recent install of postgres-7.4.5 on a MacOS 10.3.5 system. I'm attempting to build PyGreSQL-3.5, which appears to require the postgres include dir. ...

PostgreSQL Database

Configuring PHP 5.2.0 with Postgres 8.1.3 (no source)

by: Jack Orenstein | last post by:

I'm trying to configure PHP 5.2.0 with support for Postgres 8.1.3. Postgres was installed with FC5 without source. PHP's configure needs source. When I run configure: configure: error: Cannot...

PHP

storing SMALL large objects to postgres with C# (.NET ODBC layer)

by: NM | last post by:

Hello, I've got a problem inserting binary objects into the postgres database. I have binary objects (e.g. images or smth else) of any size which I want to insert into the database. Funny is it...

C# / C Sharp

recordset.addNew() with postgres

by: michal | last post by:

hi guys, i am using postgres 8.2 and try to add some records to a table with ADODO ... unfortunately i end up with an error when calling the addNew() method. it says that the recordset does not...

ASP / Active Server Pages

Run Unix Shell Scripts With Postgres Trigger

by: sainathr | last post by:

Hi, I would like to run shell scripts with respect to the time mentioned in postgres data base tables. Postgres database should trigger the shell script for the time mentioned in the table. To...

PostgreSQL Database

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...

Networking - Hardware / Configuration

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

C# / C Sharp