Suppose I have an element in a table and want to skip it. In my case I have a timer script that I am implementing and I want it to check in php / SQL:
for example I have the following table:
id name jobpostion
----------------------------------------
0 Dave seniorengineer
1 Bob designer
2 Will Programmer
4 Ted Sysadmin
Notice that id no.3 is skipped:
How do I skip it:
My question is :
How do I implement the code below to skip element 3 in the table (so as not to give me an error)
ie
if (id does not exist)
{
id ++;
if (id still does not exist
90 DBMS_SQL::
Skip Headers. PL/SQL Packages and Types Reference. 10g The procedure concatenates elements of a PL/SQL table statement and parses the resulting string.
http://download-west.oracle.com/docs/cd/B14117_01/appdev.101/b10802/d_sql.htmHOME |
SQL Statements: ALTER TABLE to ALTER TABLESPACE, 2 of 3::
Skip Headers. Oracle9i SQL Reference. Release 2 (9.2) Part Number A96540-02. ALTER TABLE. Purpose You must specify an element, although the XMLSchema URL
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/statements_32a.htmHOME |
{
id =0;
}
}
Please help. Page 13 - Extracting Metadata::
The TableColumn element contains information retrieved from SQL Server. The child table element doesnt need to list the parent key fields because its
http://www.aspfree.com/c/a/Database/Extracting-Metadata/12HOME |
Sample XML Format Files::
In the <ROW> element, the format file maps the column Age to the first field, Using a Format File to Skip a Table Column. Using a Format File to Skip a Data Field
http://technet.microsoft.com/en-us/library/ms191234.aspxHOME |
Can someone please help
ok here is another form for the question:
How do I just skip element three?
or
How do I check that an id number dees not exist (ie 3 does not exist in the table above)?
Please help this is urgent!!!
I am sorry let me rephrase the question:
How do I skip a non-existing row, not the last row
supose I had rows 1, 2, 4.
How do I let it know that row three does not exist???
select * from $tablename where $element = ''
Ok let me rephrase the question:
How do you check for an empty element in a table??
if ($element_in_mytable_is_empty)
{
}
 Where's The Advantage In Windows Genuine Advantage?
 Stocks Bounce After S&P Joins Bear Market
|
