Search results for query: *

Is its safe to create static level methods to handle database access? DataAccessor.GetDataSet("spName",params); Or should these be instance methods? DataAccessor da = new DataAccessor(); da.GetDataSet("spName",params); I created a class to remove some of the complexities of the data access...

I have a SP that contains a cursor with an inner cursor. The SP works mostly but in the inner cursor I get an error after it updates the first record. Below is the info: Error: "Error: Number (560) Severity (16) State (1) Procedure (_test) The UPDATE/DELETE WHERE CURRENT OF failed for the...

I don't know much about ActiveX components, so I apologize if I'm way off here. ActiveX components allowed you to do things with a browser on a client machine that would normally not be permitted, like access the drives or printer. My question is what does .NET offer to replace ActiveX...

I have to build a site where a user can pass a file of zip codes and gets a result set of the closest office to each zip. The problem I have is performance. No matter what server side language I use, I will have to fire off a query for each zip code in the file. So if I receive a file of 100 zip...

I'm having a hard time proving the value in creating and using interfaces. I thought maybe if my derived classes all had the same base class or interface in this case, I could cast between them like so... class TestInterface{ [STAThread] static void Main(string[] args){ Queen queen =...

I posted the in SQL2000 but it could be someone in C# can give me a clue. I am inserting a C# generated XML file into SQL2000. http://www.tek-tips.com/viewthread.cfm?SQID=783531&SPID=183&page=1" Thamks for your help!

I have a C# program that sends and XML file to an SP that updates/inserts the data into the appropriate table. Has been working fine since I put it together a few months ago. Now I want to add another update/insert into the process but im getting an error. All of the code is the same; the data...

I feel like my last post thread183-738120 had to much info. So here is the short of it. When I add the datepart function to the query it fails. The error I get is: Server: Msg 8630, Level 17, State 38, Line 1 Internal Query Processor Error: The query processor encountered an unexpected error...

I have an SP that I am moving from Sybase, where it works. I am able to compile it but I can't run it. I narrowed it down to one part of the code: datepart(year,b.week_date)=datepart(year,z.week_date) I checked the value of the field and they seem to be correct [week_date] [smalldatetime] NOT...

I have an SP that does exactly what it is supposed to do in Sybase (return a set of records). I am trying to get the same results in SQL2000. But when I run the SP from CF or ASP both are throwing an error alluding to the recordset does not exist. The SP is kind of long so I started to break it...

No the parameter exist! I am converting a web page from Sybase to MSSQL. Not much different (TSQL) in fact everything has run smoothly with one exception. The page runs a query but the very next line that references the query throws an error: "Error resolving parameter". Makes no...

I created a package that contained one SP "s_user_authenticate" I call this procedure from a web page, everything works fine. Now I added another SP and the package compiled fine. But now the web page that worked fine with the first procedure is throwing the following error: Microsoft...

Is it something that can be used on the web? Everything I can find on it points to client server tech that is 3 generation old technologies. Most sites lead me to beleive any VBX should have been replaced with Active-X years ago. I have some joker trying to act knowledgeable he made the...

I'm using CF 4.5. Can't figure out why this would happen. I have an SP with an insert statement. Everything works fine except for parentheses and double quotes. This happened in more then one SP and/or page. It's an intranet site so I was able to make a rule that parenthesis and double quotes...

My session vars are not timming out when I set them to. In my Application.cfm page I have... <CFAPPLICATION NAME=&quot;itsite&quot; SESSIONMANAGEMENT=&quot;Yes&quot; SETCLIENTCOOKIES=&quot;Yes&quot...

How do I use a variable as a file pathe in the append from command? This is what I have... USE cse_sdm.dbf IN 0 EXCLUSIVE SELECT cse_sdm zap x = (substr(cmonth(date()),1,3)+alltrim(str(year(date())))) fpath = &quot;\\phoenix\e\&quot; + x + &quot;\td.xls&quot; APPEND FROM (fpath) TYPE XL5 SHEET...