473,327 Members | 1,952 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,327 software developers and data experts.

need help deleting multiple records -

I am retrieving records for Customer ID as follows and displaying them
as table rows with a checkbox for multiple deletion.

Part of a </FORM>
************************************************** **************
$recordset=Array();
$c=0;
while (ora_fetch_into($cursor,$recordset,ORA_FETCHINTO_N ULLS|
ORA_FETCHINTO_ASSOC))
{
echo "<TR>".
"<TD><INPUT TYPE=Checkbox name=No[ ] Value=".$c."></TD>".
"<TD>".$recordset["CUSTID"]."</TD>".
"<TD>".$recordset["TITLE"]."</TD>".
"</TR>";
$c=$c+1;
}
************************************************** ***************

I am quite confused what should be my query string in the submit file.
I want to delete matching Customer IDs in the table from the checked
records. Please suggest how I can frame the query. I am currently able
to delete just one record.

-CD

Jul 17 '05 #1
2 1753
I am trying
print $HTTP_POST_VARS['No'];
to see what the array contains but getting Undefined index: No as an
error message.

Jul 17 '05 #2
I noticed that Message-ID:
<11*********************@o13g2000cwo.googlegroups. com> from
co***********@yahoo.com contained the following:
$c=0;
while (ora_fetch_into($cursor,$recordset,ORA_FETCHINTO_N ULLS|
ORA_FETCHINTO_ASSOC))
{
echo "<TR>".
"<TD><INPUT TYPE=Checkbox name=No[ ] Value=".$c."></TD>".


I don't know about the query string but I suggest you look at the html
first.

<TD><INPUT TYPE=Checkbox name='No[ ]' Value='".$c."'></TD>".

And shouldn't the value be the id?

<TD><INPUT TYPE=Checkbox name='No[ ]'
Value='".$recordset["CUSTID"]."'></TD>".

Then try a print_r ($_POST['No']); and see what you get.


--
Geoff Berrow (put thecat out to email)
It's only Usenet, no one dies.
My opinions, not the committee's, mine.
Simple RFDs http://www.ckdog.co.uk/rfdmaker/
Jul 17 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: rishi | last post by:
Looking for tips on how to improve performance on deleting records. In our database we do dataloads daily that require us to purge millions of records a day so any improvement in speed would be...
5
by: Alex | last post by:
Hi, I have two tables , A and B where table B has a foreign key constraint to table A. I want to delete all records in table A that are older than a certain date that are not referenced by...
1
by: Mark | last post by:
This question refers to a main form with a continuous form subform. After an error occurs after entering several records in the subform, how can I delete all the data in the main form and all the...
1
by: Marco Krechting | last post by:
Hi All, I have a continious form with records from a query. I want to highlight multiple records by clicking and holding SHIFT and after that get the bookmarks so I can delete the highlighted...
3
by: Mike Turco | last post by:
I'm working on an application that imports and exports tons of CSV data, like 64,000 records per file, and six or seven files in a set. First off, by the tine I import a few hundred thousand...
5
by: Mojtaba Faridzad | last post by:
Hi, with SetDataBinding( ) a DataGrid shows a DataView. user can select some rows in the grid by holding cotrol key. when user clicks on Delete button, I should delete all selected rows. I am...
5
by: Robert Brown | last post by:
Hi All. I have a routine that checks a SQL Table for all records 3 months prior to a predetermined date, then I insert them into an Archive DB then delete those records from the original table....
0
by: Tomazas | last post by:
Hi All, I have very complex database and I am trying to build an Shaped SQL string with no success. Could anyone help me to answer how this would look like. TABLE LIST: Asset, Structure,...
11
by: shriil | last post by:
Hi I have this database that calculates and stores the incentive amount earned by employees of a particular department. Each record is entered by entering the Date, Shift (morn, eve, or night)...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
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...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
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.