Search results for query: *

I have an sql server 2000 db running on a four processor box. The system has slowed down and performance keeps going up and down almost randomly. I'm defraging all the indecies. Is there a routine I can run to check for performance isses / errors within the database. Is there any routine to run...

I'm using <div style=&quot;height:500px;width:500px;overflow:auto;&quot;> ...CODE... </div> When I add an onscroll=&quot;alert();&quot; I get the alert box. However, when I reference the div via an ID and try to make it scroll I get an &quot;object doesn't support this property or...

Is anyone using bibit payment services? If you are have you got any code to check if the transaction is authorised or refused.

I have an SQL Server 200 Box with 2 gig or ram and 4 Processors. What I would like to do is move tasks from some of our databases to other boxs. That is some of the heavier stored procs should be on a seperate server. Firstlt is this possible. And secondly if so are there any issues.

Set oShell = WScript.CreateObject(&quot;WScript.Shell&quot;) oShell.Run &quot;command /C net send PC Que Pasa Amigo&quot;,0,True in asp Set oShell = SERVER.CreateObject(&quot;WScript.Shell&quot;) oShell.Run &quot;command /C net send PC Que Pasa Amigo&quot;,0,True NOTE THE &quot;SERVER&quot...

5 Seconds after writing this I solved the problem. Sorry. I dragged the fields from TableB into table TableA rather than the other way round, which I was doing before.

I have two Tables Table A{ ColA1 - Key ColA2 - Key } AND Table B{ ColB1 - Key ColB2 - Key ColB3 - Key } The two fields in TableA correspond to ColB1 and ColB2 in TableB. The problem is ColB3 which is a DateTime field. TableB is a log table for process' TableA has...

One important factor to note is that alot of hosting companies try to charge (~$25/dsn) for each dsn. With a dsn-less connection you can bypass this problem. When it comes to migration of dsn-less conections from one server to another theres not really a problem. With sql-server the only thing...

onclick=&quot;this.form.action='url';this.form.submit();&quot;

for 0/1 in any queries use CAST(bitvalues AS INTEGER) AS bitvalue as far as yes no goes i'm afraid its replace replace REPLACE(REPLACE(bitvalue,true,&quot;yes&quot;),false,&quot;no&quot;) pain.

The codes within an if statement so it wont be executed . fine. The code problem is that the include needs to be outside the asp tags. <% dim previous previous = Request.ServerVariables(&quot;HTTP_REFERER&quot;) 'previous now contains the value of the previous script response.write &quot;Value...

I'm looking for code to validate email address'. I'm looking for more than just checking the syntax ( an @ exists and a domain extension exists ). What i'm really after is a componant/asp method that will tell me if the email is in use. I've found a few componants for sale $100 aprox. I don't...

Oh I think the other one is 60 and &quot; is 34 &# 60 ; &#60; &# 34 ; &#34;

Create your own chr page For i = 1 To 256 Response.Write(i & &quot; &quot; & CHR(i) & &quot;<br>&quot;) Next This will give you a look up table for your codes ie x = 62 = &#x; = &#62; &#Number; will output the character;

Output all the variables to the screen to make sure they have values. You don't need the single quotes for numbers, but this souldn't cause the error.

Possibly :: The image needs to be preloaded. You are sending info to the server (form info) and recieving the resulting page, while trying to access the gif. If not try this :: <Div align=center id='Patty' name='Patty' style=&quot;visibility:hidden;position:absolute;&quot;><img...

The first option would be best as it would allow easy search of key words and titles and other properties in a single query. This will be quicker that running a query and then accessing the file system.

Page 1 DIM deleteCount deleteCount = 0 DO WHILE NOT rs.EOF deleteCount = deleteCount + 1 %> <input type=&quot;checkbox&quot; name=&quot;del_<%= deleteCount %>&quot; value=&quot;[PrimaryKey]&quot;> <% rs.MoveNext LOOP %> <input type=&quot;hidden&quot; name=&quot;totalRecords&quot...

Try FORMATNUMBER(variable,number of decimal places >= 0)

ADOcommand.Parameters.Append ADOcommand.CreateParameter(&quot;@paramAMOUNT&quot;, adNumeric, adParamInput, , 10000) ADOcommand.Parameters.Append ADOcommand.CreateParameter(&quot;@paramRESULT&quot;, adVarChar, adParamOutput, 1) ADOCommand(&quot;@paramAMOUNT&quot;) = Increase ADOCommand.Execute...