Hi,
I'm running sql server 2008. I have a varchar(2000) col and need to do fast fuzzy text searches on it. Can anyone advise on the best way to do this please.
Thanks
TimSki
Last Activity: May 26 '12, 05:42 AM
Joined: Jan 29 '08
Location:
-
ok thanks but i'm confused as to why u think this has nothing to do with ASP, it's an ASP site. I'm referring to articles such as this which seems to be fairly common practice http://forums.aspfree.com/code-bank-...sp-157948.html. My question is simple whether to redirect/transfer or keep everything within the 404 ? -
404 and SEO
Hi All,
I have created a custom 404 page. I can now publixh URLs such as www.mydomain.co m/England/MyHouse and then use code in the 404 page to interpret the URL, look up the parameters in the DB which relate to 'England' and 'MyHouse' and publish the relevant page.
This works great but it's very important that google picks up my link www.mydomain.co m/England/MyHouse and indexes correctly.
So with SEO... -
yes its'a good thought but I have plenty of experience with people seemingly unable to read instructions ;) ! A tech soln would be the best if possibleLeave a comment:
-
yes thanks but i realise that. going back can't (or shouldn't) be disabled and disabling caching will cause other problems i'm sure (also not great practice). i was hoping there was another solution but maybe not :(Leave a comment:
-
they're not going back to see what they did especially, it's just that they return to the listing page to carry on looking down the adverts. it's not something that happens a lot but it does happen and it causes problems (these are paying customers) so it would be nice to find a solutionLeave a comment:
-
ok bit more detail - my site lists property. On each advert there is an 'add to your selection' link. When they click on this the text is changed into 'The advert has been added to your selection' (This is the text inside the div). They then click on the tab 'My selection' where they see the advert selected. they then go back to the listing by clicking on the back button and see the advert they selected now says 'add to your selection' which...Leave a comment:
-
sorry don't really understand. so if they are not cached why do i see that behaviour and how can i resolve it ?Leave a comment:
-
InnerHTML Caching
Hi,
I have an asp page with for example:
<div id="introText"> </div>
next to this is a button. when then user clicks on the button I fire some javascript
function doThisWhenButto nClicked() {
document.getEle mentById('intro Text').innerHTM L = "Hello Everybody";
}
so once the button is clicked I see "Hello Everybody"... -
XMLHttpRequest
Hi,
We are using XMLHttpRequest to request a script on a remote server.
Say i have a page called getInfo.asp. If i call getInfo.asp 10x in a row they will be queued ie the 2nd call will start once the first is finished etc so that my 10th call could take a very long time to complete.
If i call getInfo.asp from 10 different computers then they will be in seperate sessions so they won't wait on each other.... -
thanks but that wont work because i don't want to bring back the recordsLeave a comment:
-
Abort count if given number exceeded in SQL query
This is probably a dumb question...
but,
I have a large table 10M rows. I want to do a typical sql count BUT i want to abort the count (and return me the count so far) if it exceeds a certain number
kind of...
select count(id)
from bigtable
where maxcount cannot exceed 200
any ideas ? -
that's great. unforntumately the page is behind a login so the validator always reverts to the login page - is there anyway around this ?Leave a comment:
-
Elements on page are aligned incorrectly after changing Doctype
Hi,
I've jus added this line to the top of my classic asp page
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Strict//EN">
now lots of the elements on my page are aligned incorrectly.
have i done some bad programming or something ?! -
High number of executions in Key Lookup
Hi,
In MS SQL server mangement studio i'm running a problem query and looking at the actual execution plan.
I've noticed that part of the plan (the most costly part) is a 'key lookup' on the table's clustered index.
Looking at the properties of this key loopkup everyhting seems reasonable. The only thing which looks wrong ?? is the 'Number of Executions' which is 8126.
Is this a problem.... -
record count
Hi,
I'm using classic asp and an adodb recordset to get data from my database.
having run the sql statememt and retruieved the rows, is it quicker to do a record count by either doing...
1. .Recordcount
or
2. .getRows with a UBOUND on the resulting array
???
Thanks is advance -
is it possible to make use of Request.ServerV ariables(HTTP_U SER_AGENT) to detect the browser type and then make decisions on that ?Leave a comment:
-
yes exactlyLeave a comment:
-
ok thanks, but i don't really understand. i thought that some mobile devices didn't support css ?Leave a comment:
-
How to detect if user is on a mobile device browser?
Hi,
Is there an easy way in CLASSICasp to see if a user is accessing a page via a mobile device.
Thanks in advance
No activity results to display
Leave a comment: