Recent content by unseth

try http://www.deepmetrix.com and http://www.webtrends.com

hm.. not sure you can do an order by like that. What you might have to do is two select statements. One to pull out the AssignedTo for the logged in user, then another that orders it for everyone else except the assignedTo person. The second one can be ordered whatever way you need.

This should solve your problem: http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q295/2/97.asp&NoWebContent=1

going off stevedi's code, you can use an exit for <% dim fs,fo,x set fs=Server.CreateObject(&quot;Scripting.FileSystemObject&quot;) set fo=fs.GetFolder(&quot;c:\folder\&quot;) loopnum=1 for each x in fo.files 'Print the name of all files in the foldername folder Response.write(x.Name &...

you are going to have trouble because the like operator expects the # sign to mean any single digit. you can try try replacing the users input # with [#]. That might work. i.e. tosearch = Request(&quot;size&quot;) Replace(search,&quot;#&quot;,&quot;[#]&quot;) (note: i might not have...

i'm unclear what you are asking... do you want to know how to create a search on text in asp? or are you looking for cart software to make an online shop? or .. what?

what you should do is this: SELECT tblMainMenu.m_title AS maintitle, tblSubMenu.m_title AS subtitle, ....... every db has its own syntax. Sql vs. mysql vs. oracle vs. access... etc. it also depends what you're calling it from (vbscript, c++, query analyzer, etc.) in the above example...

you are trying to test empty/null on a sql result set right? Select * from carlist where model IS NULL if your field name is actually called &quot;type&quot; and the is null doesn't work, then try putting brackets around it because type is usually a reserved word select * from carlist where...

I'm using mysql currently, and i want to lock a record, update it, and get the current id. For example, I have a table with a field called nextmsg (int). On my sql statement, i want to update the nextmsg + 1, and get the new value. I was doing the following: set rslck =...

interesting.. that seems to work. I would think that would be more expensive, i'll have to look at the execution plans. thanks

I've located a slow moving SPO and narrowed it down to the following. I've simplified it here for ease of reading (in actuality, the second contains is not a contains, but an openrowset on something else, but for the problem is still the same) Select a,b,c FROM table1 WHERE (date_retrieved...

oops i forgot, after 20:30 and before the ) there should be another '

WHERE (r.date_time BETWEEN '9/1/2002 06:30' AND '9/30/2002 20:30) AND r.ct_id = 1

I have 3 machines. machine 1. Sql server 2000. windows 2000 server. updated to MDAC 2.62.7926.1 machine 2. windows 2000 server. updated to MDAC 2.62.7400.1 this seems ok, since they say its the same version, only the version # is different. However, machine 3. windows 2000 pro...

I have an ole db provider that i call this way select filename from mpaole...[this is my input] however, if my input exceeds 128 characters, I'm given the error 103 that the maximum length is 128 characters. I know this deal's with quotes, and setting QUOTED_IDENTIFIER OFF, however, there...