Search results for query: *

Perhaps the database field and the querystring are of different types. I assume that the ContactID field has a type 'Int'. Try casting the querystring to an int. CInt(Request("CID")) Mitch What happens if you get scared half to death twice?

You don't need the brackets around your variable names. If it is still concatenating your results, then make sure all of the variables are numeric, if it they are strings then '+' may be interpreted as a concatenation operator instead of addition. Mitch What happens if you get scared half to...

cheers mate, i think I am on a roll now... What happens if you get scared half to death twice?

my mistake, I had a few too many things going on in the for loop. the code I have folows, and I want to output the value of s_ref_chkdig stringVar s_ref_chkdig:= ''; numberVar total := 0; numberVar i := 0; for i := 1 to 7 step 1 do ( total = total +...

I am using Crystal Reports 8.5, and am new to the product so must apologise for my limted knowledge. I have a formula field which takes a unique identifier from my database and adds a modulus 11 style check digit to the end. The formula I have written should provide the correct results. When...

I have been handed some code which utilises ixsso.Query. The drive which the code is Querying is indexed, and I have gone through the code closely to check for any obvious mistakes. The problem is that running the same query can bring back different results. It seems sparadic, but for...

try something like this dbcc checkident(tablename,reseed,1) you will need to have deleted the data or truncated the tables first.

Pehaps import in stages, maybe 20,000 at a time. Smaller imports won't use as much Log space. If using Enterprise Manager, import using query and do: select top 20000 * from mytable then delete the top 20000 from the original table, truncate the transaction log and repeat until you have finished.

try something like this... Order by CONVERT(int,REPLACE(citation, '[2002] CFLQ ','')) This will remove the [2002] CFLQ from the beginning and turn the number into an int which can be ordered as such. Mitch Bournemouth UK

Left(string1, 255)

ignore that I was in Javascript mode... i'll get back to you.

Try this, I haven't tested it... (if you have any syntax problems see http://www.devguru.com) function split(mystring){ var string1 = mystring; var string2; for (i=0;i=255;i++){ string2 = string2 + string1.charAt(i); } } this could be modified to get the next 255 chars aswell if you want...

SQL Server does not output ASP. ASP can connect to SQL Server to output data from tables. However it is an independant product which must run on a web server. Pehaps you should try the IIS or ASP forums.