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...
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 =...
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.
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%")
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.
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...
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
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
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...
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
The include is for the content of the page. Here is the code which isn't working.
....
<%
newsid = Request.querystring("id")
....
set newsSet = lawtalkDB.Execute("select * from news where id="&newsid)
thePage="<!--#include virtual='"...
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.