Search results for query: *

you're getting the id from the other database but checking your current database's sysobjects table. and i think OBJECTPROPERTY only works in the current database. this should work. if exists (select * from GLOBAL_POS.dbo.sysobjects where id = object_id('GLOBAL_POS.DBO.NA_052003_BP') and xtype...

i don't know of a built-in function that will do this. here is a function that will do it though Create function dbo.AddDigits ( @intNumber int ) Returns int AS Begin declare @strNumber varchar(20), @intReturnValue int Select @strNumber = Cast(@intNumber as varchar), @intReturnValue =...

<form action=&quot;calc_score&quot; method=&quot;post&quot; name=&quot;myForm&quot;> should be <form action=&quot;calc_score.asp&quot; method=&quot;post&quot; name=&quot;myForm&quot;>

looks like a SQL Server error. try calling SET DATEFORMAT dmy to tell sql server to expect the day first.

SELECT * FROM TableName WHERE FieldName IS NULL

sorry. that should be <thead style=&quot;display:table-header-group;&quot;>

try <thead style=&quot;&quot;display:table-header-group;&quot;&quot;> <tr> <th>Header</th> </tr> <tbody> <tr> <td>Rest of page</td> </tr> when you print or print preview it will display the header at the top of all the pages

try SELECT * FROM [server-1].msdb.dbo.backupset

this should work RIGHT(CAST(Year(CreateDate) AS VARCHAR), 2)+'^'+ CASE WHEN Month(CreateDate) <= 9 THEN '0' ELSE '' END+ CAST(Month(CreateDate) AS VARCHAR)+'^'+ CASE WHEN Day(CreateDate) <= 9 THEN '0' ELSE '' END+ CAST(Day(CreateDate) AS VARCHAR)

you could create an INSERT trigger that returns the newly created identity value. SELECT IdentityField FROM Inserted

str = &quot;<li><A HREF=&quot;&quot;javascript:doMarker('abc');&quot;&quot;></a>&quot; you have to have the two different types of quotes if you're going to nest them.

try changing document.location to document.location.href

i don't want to know if an error has occured. i know how to check that. i want to know if there's a way to check to see if &quot;on error resume next&quot; has been called.

is there anyway to check to see if a page has set on error resume next? i want to do something like check to see if on error resume next has been set on error resume next do something that may raise an error if on error resume next was not set then on error goto 0 does anybody know if that's...

ok. i changed if (isNaN(claimsBox.value))) to if (isNaN(Number(claimsBox.value))) and added the closing } for the function formValidation and it displays the please enter a number alert

that shouldn't matter. how big is the generated HTML file? would you be able to post it here?

do you have a link to the page i can see? i am very confused as to why what i wrote isn't working

ok. try for (var boxCount = 1; j < 12; boxCount++) { eval('ClaimsBox = currentForm.txtNumClaims'+boxCount); if (isNaN(Number(ClaimsBox.value))) { alert(&quot;Please enter a number.); ClaimsBox.focus(); return false; } }

either single or double quotes should work fine. what error are you getting? what is the isItNumber function expecting? the form element or the form element's value? the above code passes the form element.

try for (var boxCount = 1; j < 12; boxCount++) { eval('ClaimsBox = currentForm.txtNumClaims'+boxCount); if (isItNumber(ClaimsBox) == false) { alert(&quot;Please enter a number.); ClaimsBox.focus(); return false; } }