Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. bellmd

    Using UPDATE in SQL

    Having now tried all possible combinations of the above, I have got it to work using the statement below; update blank_date set name='Matthew', telephone='678', email='matthew@sexycooking.co.uk' where (date = #7-Jan-2001#) or (date = #8-Jan-2001#) Changing e-mail to email was a good tip...
  2. bellmd

    Using UPDATE in SQL

    The SQL statement at the top of the list gives the error message; [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2.
  3. bellmd

    Using UPDATE in SQL

    I've tried that but it still won't work.
  4. bellmd

    Using UPDATE in SQL

    There is a problem with this SQL statement. The problem is with the set command, with only one value to change it will work fine, but with more than one it returns an error. UPDATE blank_date SET name='Matthew' and telephone='678' and e-mail='matthew@sexycooking.co.uk' WHERE (date =...
  5. bellmd

    searching 2 db fields

    Yes, the syntax is correct. That is what I am currently using, and it works well. The main problem is that not all the records have a description, because some have sufficient information in the title, and without serching the titles also some of the record will not show up in through the search.
  6. bellmd

    searching 2 db fields

    I'm trying to search two fields in a database. The SQL statement below returns all the records in the database: select * from table where (desc OR title LIKE "%this%") AND (desc OR title LIKE "%that%")
  7. bellmd

    loop within a loop

    This does not sound that tricky, but to help we'll need a few more details.
  8. bellmd

    Removing dupliates from arrays

    Does anybody know of a goog way of removing duplicate values from an array? I presume that the values will have to be put into a new array as they are filtered for duplicates, but have yet to find a way of filtering them. In advance thank you to anyone who can shed some light on this problem for me.
  9. bellmd

    ASP post method

    Dear Eek, What are you finding difficult about the POST method, in my experience I don't see it as being any different to GET, other than the querystring is not used to send information. The only major difference between forms using GET and POST is that when you want to pull the...
  10. bellmd

    Going backwards through recordsets

    Cheers. That is what I tried initialy, but it didn't work, this was, as you pointed out, due to the cursor type. That has solved another problem. Thanks again. Also the recordset.getrows will come in use some time I'm sure. Matthew Bell
  11. bellmd

    Going backwards through recordsets

    Cheers, that's great, I also have had some great help from people on this site, which includes you ciberperson. Thanks again, bellmd matthew@sexycooking.co.uk
  12. bellmd

    Going backwards through recordsets

    I'm trying to use recordsets to display a list of items, this is simple, but I don't seem to be able to display them in reverse chronological order (most recent first), as they are added into the database in chronological order. I have tried several things, but they all cause errors of some...
  13. bellmd

    dynamic content

    Thank you very much Rob and Nick, your help has been great. I'm not sure what the site will be run on eventually, so I can't say if it will be using IIS 5, although I imagine that it will. I think that either using IFRAME or ILAYER is my best bet. Cheers, Matthew matthew@sexycooking.co.uk
  14. bellmd

    dynamic content

    The include is for the content of the page. Here is the code which isn't working. .... <% newsid = Request.querystring(&quot;id&quot;) .... set newsSet = lawtalkDB.Execute(&quot;select * from news where id=&quot;&newsid) thePage=&quot;<!--#include virtual='&quot...
  15. bellmd

    dynamic content

    I am trying to create a two page system which has one page displaying a list of articles and a second which displays the the individual articles, selecting them from information in the querystring. I tried to use a server side include, although it's writen to the page it does not get executed.

Part and Inventory Search

Back
Top