Change Record Order in DB Interface Wizard

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way I can change the order the records are pulled into the DB Interface Wizard? For example, let's assume I have two fields in a table; Name and NameID. When I run the DBIW to gain the ability to edit/delete records out of the database, it makes the first field as a hyperlink in the database_editor.asp. My trouble is that I want the NameID field to be the hyperlink field.
 
YOu can modify your query by adding an ORDER BY clause. Example:

SELECT * FROM MyTable ORDER BY SomeColumn ASC

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.

AC said:
Is there a way I can change the order the records are pulled into the DB
Click to expand...
Interface Wizard? For example, let's assume I have two fields in a table;
Name and NameID. When I run the DBIW to gain the ability to edit/delete
records out of the database, it makes the first field as a hyperlink in the
database_editor.asp. My trouble is that I want the NameID field to be the
hyperlink field.
 
switch the two fields (NameID and Name), then copy the hyperlink tag from
Name to NameID and delete the hyperlink from Name.

Mikeal

AC said:
Is there a way I can change the order the records are pulled into the DB
Click to expand...
Interface Wizard? For example, let's assume I have two fields in a table;
Name and NameID. When I run the DBIW to gain the ability to edit/delete
records out of the database, it makes the first field as a hyperlink in the
database_editor.asp. My trouble is that I want the NameID field to be the
hyperlink field.
 
Back
Top