Search results

well, that logic won't work because if the session expired then they are already "logged out" so to speak so if you have a logout page that requires authentication to get to (which appears to be the case) then you should change your forms auth so that the logout page does not require...

you're execing a string try SET @SQL = 'SELECT tblClient.Country, dbo.tblClient.cName, dbo.tblClient.clientID, dbo.tblClient.Wholename, dbo.tblClient.TelNumberG, dbo.tblClient.TelNumberD, dbo.tblClient.City FROM dbo.tblOrders INNER JOIN dbo.tblClient ON...

that's a big one.. here's another one that's a little more organized CREATE FUNCTION dbo.fn_Split (@text varchar(8000), @delimiter varchar(20) = ' ') RETURNS @Strings TABLE ( position int IDENTITY PRIMARY KEY, value varchar(8000) ) AS BEGIN DECLARE @index int SET @index =...

yes, select count(*) does have much overhead. I used the sproc in the link I gave and expanded on it to include more flexibility in the sproc for grouping etc. I was able to use this to build a gridview class for classic ASP that works quite well and the query is fast as it only selects the...

if you make an Access Project out the app, then by default , all "queries" you create are stored procedures. You don't have a choice.

this might help..might not...take a look. http://weblogs.asp.net/pwilson/archive/2003/10/10/31456.aspx

you can get the sql 2005 express edition for free and you can use the CTP to manage it. http://www.microsoft.com/downloads/details.aspx?FamilyID=82afbd59-57a4-455e-a2d6-1d4c98d40f6e&DisplayLang=en

I hear ya man, I actually dev 80-90% in classic ASP at work.. *BLECH*.. infact, I just built a pagable, sortable gridview class and stored proc to go with it over the past few days so I can plop a grid in where I need it and not have to screw around with copy paste. It acts similar to a GridView...

My recommendation is that if you don't know ASP that you skip it and move right to ASP.NET. There's a bit of a learning curve to it but once you can a handle on the basics, you can make sites with those features you want rather quickly. VS.NET Express is free...

Try making another user in sql server that can login to that database. Then use those credentials for the project connection and see if that works.

how did you set up the connection on the clients? did you use windows authentication or SQL authentication?

got it..my text was being padded with whitespace and the convert was cutting the text at 50 characters. I removed the convert for the @SQLText and @SQLFor and used a regex to replace 2 or more whitespaces with just one whitespace and passed that to the procedure.. bicketty bam! :)

I'm trying to setup a paging query in SQL server 2000 and I'm having a real pain in the butt time with it. What I want to do is pass in the text of the query and execute it. So @SQLFrom would contain " From [tablename] " but I keep getting [Microsoft][ODBC SQL Server Driver][SQL...

ok, got that one sorted by using exec sp_helptext 'sprocname'

Getting stored procedure source text? Hello, I was wondering if anyone knew how to obtain the source text (i.e Select x from table) of a stored procedure using any SQL server commands or functions.. Thanks.

you should be using sql server 2000. SQL 7 is nearing EOL and has moved to special support in MS. In any case, Your client ony needs MS-Access installed. SQL server can communicate with your project over a network, so when you set up your MS Access Project, it will ask you for the server...

did you check the record in the database to make sure the whole content is actually there?

http://www.mssqlcity.com/FAQ/Devel/first_month_day.htm http://www.sqljunkies.com/Article/6676BEAE-1967-402D-9578-9A1C7FD826E5.scuk

then why not use the second suggestion which is to UPPERCASE them in the front end code ?

varArray=split(variable,"string to split on") now it's in an array..