Re: Database searching via asp/vbscript

For your SQL command check out the LIKE command

SELECT * FROM TABLE WHERE FIELD1 LIKE 'VARIABLE'


"accyboy1981" <accyboy1981@xxxxxxxxx> wrote in message
news:1134747348.174424.267310@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Hi,
>
> I've created a database that holds information about a netowrk. It
> holds all the computers details such as hardware installed (including
> vendor etc), software installed, users, network info (i.e. ip address,
> dns, subnet mask etc). I've also created a mini-forum where people can
> post info about there computer as well. Needless to say there are
> number of different tables in this database. I've already created a
> website that displays all this info and can add/delete to it. However I
> would like a detailed search on the site where I can search multiple
> table e.g. say I want to search for a pc name begining with md* and has
> an intel cpu and ms office installed with comments in the forum by the
> administrator user. To create this search is relatively simiply
> providing all the searches will be the same however they will vary. Is
> there already a method for creating searches such as these? If not does
> anyone have any advised on where to start.
>
> Thanks
>
> Simon
>


.

Relevant Pages

  • Re: How to protect Python source from modification
    ... They can then execute any arbitrary SQL command. ... >>SQL commands on their own database, who are you to tell them they ...
    (comp.lang.python)
  • Re: SQL commad each time I open MS Word
    ... Opening this document will run the following SQL command: ... information from a database -for example, if your document is a form letter ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: Trouble w/ create table sql on mx.ODBC
    ... I can't get the 'create table' sql command to work. ... (ignore the geoprocessor object for ArcGIS): ... or does the program complete without any apparent change to the database? ... It might be because Access doesn't automatically commit DDL changes like some other databases do. ...
    (comp.lang.python)
  • Database searching via asp/vbscript
    ... I've created a database that holds information about a netowrk. ... holds all the computers details such as hardware installed (including ... vendor etc), software installed, users, network info (i.e. ip address, ...
    (microsoft.public.scripting.vbscript)
  • Re: Problem with "while/fetchrow_array"
    ... The first returns the last database in the known world as a row. ... I'm not sure if mysql has a mysql-only sql command you can give to get ... and execute it without any error ...
    (perl.dbi.users)
Loading