Worked great!!!
Thanks...
JWM81274
Last Activity: Aug 24 '09, 12:46 PM
Joined: Jul 9 '09
Location:
-
How to jump to another php page when script is complete?
I am trying to get back to a "home.php" after a series of if statements. I tried include('home.p hp'); but that just added the home page to the bottom. I am very ignorant when it comes to PHP programing and I can't seem to find anything other than include() when dealing with pages. -
To fix my issue I added another column called "order1" to all the oracle tables I am using. When the data was pushed into oracle I also pushed the order I wanted displayed on the PHP page into the column "order1". In the script for PHP I used order by "order1" asc. Which ordered the data correctly. Thanks again for the help.Leave a comment:
-
Thanks for all the help.Leave a comment:
-
I am trying to order by inserted in the table. ROWID ASC(ascending order) doesn't match when it was inserted. I tested with inserting 9 rows at one timestamp 10 times and when sorted by ROWID ASC(ascending order) the timestamp rows don't always allign. I don't understand why exactly. It maybe the ASPEN IP21 version of SQL+.
I did fix my issue another way though.Leave a comment:
-
I just added a column to all the tables that I placed an numeric value and ordered by that column. ROWID didn't work because the order created is not the same as when you order by ROWID. The ID created uses + ,\ , "A", "a", and #'s 0-9 in the ID that order. When you order by ROWID ASC the + is at the top then the \, followed by 0 through 9, then "A" and lastly "a". If the ROWID of the values crosses from...Leave a comment:
-
It appears as though it is the ROWID that is out of order. I looked at the ROWIDs and for some reason the first insert statement is getting an ID that is not in order with the rest. Sometimes the ID is an earlier one sometimes it is a later one. Here is the script I am using, shortened for display:
...Code:INSERT INTO "TABLE1" (DATE1, SHOPS, KILN_DAY, DAY_OF_YEAR) VALUES (LOCAL.DATE1, 'COAL',"HISTORIAN DATA",LOCAL.DAYOFTHEYEAR);
Leave a comment:
-
newb question about sql+ script for appending to end of table
Is there a statement that will allow appending to the end of table when inserting new data? I use multiple "insert into table1(timestam p1,area1,value1 ,value2...)" to insert different area data with the same timestamp into the same table. When I look at the data in the table sometimes the rows are placed randomly into the table. When I queue a php script to display the data for a particular day the order changes because the order in the...
No activity results to display
Leave a comment: