473,320 Members | 1,965 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Database record in a form

HI,

I am trying the following any help in getting to my target would be great.

My design is as follows I have a form (say formA) which has only one text field for account_id and then i have a search button, Now when the user enters a account number and presses search I want the record to be displayed as a form which will have all the fields in the database and also two buttons update and OK ,such taht if the user changes anythibng in the record and presses the update buttoon the record in the database should be updated.

Thaks for all the help in advance.
Mar 17 '08 #1
5 1235
KevinADC
4,059 Expert 2GB
Look into the CGI module for form generation and form processing and the DBI module for your database interface. DBI is not a core module though so it may need to be installed.
Mar 17 '08 #2
Look into the CGI module for form generation and form processing and the DBI module for your database interface. DBI is not a core module though so it may need to be installed.

HI thanks for the response but I have no DBI modules or anything i can install as i do not have access to the server but as far as I know this should be quite straight forward and may be i did not explain my question correctly I will try to reexplain here.

Basically I have a form which accepts curtomer_id and when submited displays the record as a single row in the HTML format. We will get only one record as custoemr_id is primary key.

I want exactly the same thing to happen except that i need the display as a HTML form instead of HTML table so taht the user can view the data and make changes if required.

I guess this is clear

Thanks
Mar 20 '08 #3
KevinADC
4,059 Expert 2GB
HI thanks for the response but I have no DBI modules or anything i can install as i do not have access to the server but as far as I know this should be quite straight forward and may be i did not explain my question correctly I will try to reexplain here.

Basically I have a form which accepts curtomer_id and when submited displays the record as a single row in the HTML format. We will get only one record as custoemr_id is primary key.

I want exactly the same thing to happen except that i need the display as a HTML form instead of HTML table so taht the user can view the data and make changes if required.

I guess this is clear

Thanks

Not clear to me. But if you need to access a databse and you can't use the DBI module you will have to write it all out by hand I guess. I have never done that myself. As fas as the form goes, like I already said, look into the CGI module, it comes with perl so should be installed. You can read all the core perl module documentation on http://perldoc.perl.org
Mar 20 '08 #4
eWish
971 Expert 512MB
This should be easily achieved. It will just be a matter of writing your script to display the data in the form. Just populate value attribute of your texbox with the data you from your DB. Read up on the HTML portion of the CGI pm.

--Kevin
Mar 20 '08 #5
This should be easily achieved. It will just be a matter of writing your script to display the data in the form. Just populate value attribute of your texbox with the data you from your DB. Read up on the HTML portion of the CGI pm.

--Kevin

I will go through teh doxcument and hopefully will succeed itf i come across issues i will post it thanks for the respponses
Mar 20 '08 #6

Sign in to post your reply or Sign up for a free account.

Similar topics

11
by: HolaGoogle | last post by:
hi all, can you please tell me what i should do to avoid session timeout when displaying my database info in my asp form (DisplayUserDatabase.asp)??? ** actualy it does load and display the...
12
by: Massa | last post by:
Hi all, I need some help on this one: I have a webpage with a form. This form submits data that goes to a mdb file (id (AutoNumber), name, email contry etc.). I would like to make another page...
8
by: RibGnaw | last post by:
Long, long ago when Access 97 first hit the streets a sample database called Northwind was shipped with it. At that time a number of articles had been posted on the correct procedure to remove all...
5
by: William Wisnieski | last post by:
Hello Everyone, I'm really stuck on how to design this application, so I thought I'd see if anyone had any general ideas on how to proceed. I'd say I'm an intermediate level Access developer. ...
12
by: Wadim Grasza | last post by:
I want to store and display (on a form or a report) multiple pictures per record in an access database. The pictures are not stored within the database. They are stored as files and the database...
0
by: Patrick | last post by:
I'm working on a contact management application, and need a hand with one aspect... Here's what I want to create: ------------------------------------ A form split into two parts. There is a...
16
by: Ian Davies | last post by:
Hello Needing help with a suitable solution. I have extracted records into a table under three columns 'category', 'comment' and share (the category column also holds the index no of the record...
1
by: Muchach | last post by:
Hello, Ok so what I've got going on is a form that is populated by pulling info from database then using php do{} to create elements in form. I have a text box in each table row for the user to...
8
by: morleyc | last post by:
Hi, until recently i was quite happy to add data sources from mssql database in visual studio and drag the datasets directly onto the form this creating a directly editable form which worked well....
1
by: raaaz | last post by:
Hi dears, I am adding a record in Access database using AddNew method of recordset. here is the code of the page .. <% Set RsLibBuild = Server.CreateObject ("ADODB.Recordset")...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.