End If However, assigning the value returned by (Cold fusion web hosting)
End If However, assigning the value returned by the Format function that has been passed the recordset field can do away with this long and tedious coding, as the following line of code illustrates: sMyString = Format(rsMyRecordSet!myValue) If you are passing a date to SQL Server, what date format should you use? By default, SQL Server expects an American date format, mmddyy, but it is possible for the database to have been altered to accept other date formats, or you could be passing data to a stored procedure that begins with a date-time conversion statement (SETDATEFORMAT dateformat). The only sure way of passing a date into SQL Server is by using the ANSI standard date format ‘yyyymmdd’ (including the single quotation marks). When passing a date to a Jet (Access) database, you should surround the date with hash characters (#); for example, #12/31/1999#. Formatting numbers using Format without a format definition is also preferable to simply using the Str function. Unlike Str, the Format function removes the leading space normally reserved for the sign from positive numbers. You can also use the Format function to scale numbers by 1000. This is achieved by placing a thousands separator to the immediate left of the decimal point for each 1000 you wish the number to be scaled by. Thus: ‘one separator divides the expression by 1000 = 1000 Format(1000000, “##0,.”) ‘two separators divides the expression by 1,000,000 = 1 Format(1000000, “##0,,.”) VB .NET/VB 6 Differences The VB 6 version of the Format function defined five special symbols (@, &, <, >, and !) for creating user-defined string formats. In beta 2 of VB .NET, these symbols are treated as literal characters. See Also FormatCurrency, FormatNumber, FormatPercent Functions, FormatDateTime Function FormatCurrency, FormatNumber, FormatPercent Functions Class Microsoft. VisualBasic. Strings Syntax FormatCurrency(expression[,NumDigitsAfterDecimal][, _ IncludeLeadingDigit[,UseParensForNegativeNumbers[, _ GroupDigits]]]]) FormatNumber(expression[,NumDigitsAfterDecimal][, _ IncludeLeadingDigit[,UseParensForNegativeNumbers[, _ GroupDigits]]]])
Note: If you are looking for cheap and quality provider to host and run your java application check Astra java hosting services