Search

DatabaseDude · Thu Apr 26, 2007 12:11 am

ASP.NET 2.0 membership can be maintained using XML files, as well as an Access or SQL database. It may even be possible on MySQL, but I've never had reason to investigate.

DatabaseDude · Thu Apr 26, 2007 12:09 am

I'm thinking that cmdStoredProc.Parameters.Append needs to appear after the parameter object is created.

DatabaseDude · Tue Oct 25, 2005 2:29 pm

http://www.asp101.com/tips/index.asp?id=35

DatabaseDude · Mon Oct 24, 2005 6:56 pm

http://javascript.internet.com/forms/val-zip-code.html

DatabaseDude · Mon Sep 05, 2005 1:23 pm

Dim sqlConnection As System.Data.Odbc.OdbcConnection = New System.Data.Odbc.OdbcConnection(connectionString)

OdbcConnection.Open

Looks to me it's that you are declaring your connec ...

DatabaseDude · Mon Aug 22, 2005 8:43 pm

The variables are being passed as dates from an MS Access table: For instance, the error page shows:
select Evt_Date, Evt_name from tblCalendar where Evt_Date >= '8/20/2005' and Evt_Date & ...

DatabaseDude · Mon Aug 22, 2005 5:35 pm

<cfset start=#begin_date#>
<cfset end = #end_date#>
<cfquery name="get_cal" Datasource="#db#">
select Evt_Date, Evt_name from tblCalendar
where Evt_Date >= '#start#' and E ...

DatabaseDude · Tue Aug 09, 2005 8:54 pm

Is there a means of converting strings to hex in T-SQL?

I located one user defined function online; however, it makes use of an undocumented system stored procedure xp_varbintohexstr (located in M ...

DatabaseDude · Fri Aug 05, 2005 1:27 pm

This article does mention that it can affect other queries during the same connection: http://www.devx.com/getHelpOn/10MinuteSolution/20564. Glad it seems to be working for you now.

DatabaseDude · Fri Aug 05, 2005 5:14 am

Do you have a SELECT TOP 10 in your statement anywhere?

If you post the code you're using I'd be glad to take a look-see.

DatabaseDude · Fri Jun 24, 2005 11:39 pm

One very good use I've found for XML is when using Access Data Projects (ADPs) for a front-end to SQL Server. ADPs do not have the benefit of local storage for lookup tables etc, and there's no reason ...

DatabaseDude · Tue Jun 14, 2005 5:57 pm

This is a trick question isn't it?

Only if you take it as one Smile

Bryant

DatabaseDude · Tue May 17, 2005 7:55 pm

There are a handful of things I can think of ... would you mind posting or emailing the page code & indicate which info goes into whose site (between yours & salesforce.com), and I'll be glad ...

DatabaseDude · Mon May 16, 2005 5:14 pm

I was just curious how people code their ASP.NET pages ...

DatabaseDude · Mon May 16, 2005 5:12 pm

Is there a way in ASP.NET (VB) to determine whether an email was sent successfully, whether it bounced, etc?

Thanks in advance,
Bryant