Search results for query: *

Hi, Where can I find some good asp.net FREE controls? Many of the sites out there insinuate their controls are free, then upon drilling in, we find they are not free :-( Thanks, Paul

Hi, In ASP.NET if a user creates a new web folder in inetpub\wwwroot, he needs to tell me so I can go into IIS and click the button to create the application name. That application name is needed so that the web site can do NT authentication. How can I automate this so that I no longer need to...

Hi, I'm looking for some code snippets around connecting to sql server db's. Data Readers, grids and the whole nine yards would be nice. I've poked around the internet and have not been able to find a good collection of code snippets around this. Somewhere there must exist a good cheat sheet...

What do you guys think, will classic asp become obsolete? I wonder how long the browsers will continue to support it? I hate .net and am a bit worried about developing new web sites using classic asp (though I would prefer to continue using it). Maybe I should move to php? Thoughts? Thanks, Paul

Hi, I'm a programmer looking for a way to display a map image of a state, such as Massachusetts on a web site. The State should display each town and it's boundaries and allow me the ability to background color each town programtetically. In other words, I may wish to color the town of...

Hi, I have an FTP site where a remote host puts giant text files every so often. I need to programetically determine if the file exists and if the remote copy process has completed so I can then run some code to retrieve the file. Retrieiving the file is no problem and determining if the file...

Hi, I fought with the permissions in SQL Server 2005 to get the permissions correct to execute an SSIS package. Eventually I ended up creating a credential with my NT login name, like domain\Paul. I also had to type in and save my NT login password. All is working perfectly now. However, when...

Hi, I've been struggling all day attempting to perform a simple insert from SQL Server 2005 to MySql. I can perform the insert and it completes succesfully in query analyzer, but here's the problem: The one field in the MySql db that is a TEXT data type never populates. Here's the query...

Hi, I'm looking for a good source that may have a complete set of command references for asp.net VB. I keep all my code snippets stored in an app called "Action Outline". This app has a tree and brach interface like windows explorer. I'm trying to document all the different commands and...

Hi, I have this update routine that takes 1 1/2 hours to run in Sql Server 2000. update W set W.IP=X.IP from wow.dbo.CSG_SBB_HSE_HSL_ACP_EQP_BASE W inner join ( SELECT A.Mac,A.Ip FROM cdvsupport.dbo.tb_CmtsPollCm A INNER JOIN cdvsupport.dbo.tb_CmtsPollIfc B ON A.CmtsKey = B.CmtsKey AND...

Hi, This should be an easy question for someone who understands Javascript. I have the following code: <form name="form2"> <input type='checkbox' name='chk1' onclick="fct('1','Paul');"> <input type='text' name='Tech'"> </form> <script> function fct(cnt,user) { if...

Hi, I have a table like this: ColumnA | ColumnB C 1 C 1 C 1 C 1 C 3 C 2 D 6 D 6 D 6 D 5 I need to write a query that will show only the values that have the majority of the rows...

Hi, I use SQL Server 2000 and need to setup a DTS package that will pull data from an Oracle db each day. The problem is, in the Oracle db there is a partition set with the current date, like this: select columnA,columnB FROM Schema.TableA partition (CMEX_2007_10_26) So each day I need to...

Hi, I need to create an xml file. First I write some initial xml to the file: --Create an xml file named cmts_xml.xml exec master..xp_cmdshell 'echo ^<?xml version="1.0" ?^> > f\projects\cmts_xml\cmts_xml.xml' exec master..xp_cmdshell 'echo ^<request^> >> f\projects\cmts_xml\cmts_xml.xml' exec...

Hi, I've spent hours on this. I have the following sql: set @SSQL='SELECT * from openquery(MySqlTable,''select SampleTime,Sum(T2*.01) FROM '+@PortSamples' group by SampleTime'')' INSERT INTO SQL_Server.dbo.TableA (SampleTime,T2) --execute the text inside the @SSQL variable exec (@SSQL) The...

Hi, What is the best way to accomplish copying a table from Oracle to SQL Server? Currently I do something like this: Truncate Table SQL_Server_Table Drop Index blah.ix_blah Insert into SQL_Server_Table (blah,blah,blah) Select * from OpenQuery('MyLinkedOracleServer',Select blah,blah,blah from...

Hi, I need to find a way to display a map of Massachusetts, including all the towns. I need the ability to change the background color of different towns. If a problem occured in a town, I would color it Red, otherwise it would be Green. Thoughts on where I could locate such a thing ? I...

Hi, I'd like to know if there is a way to copy all the stored procedures in a database to a text file ? I use a program called Action Outline to store all my commands and code snippets. I'd like to keep the stored procedures in Action Outline for reference. Thanks, Paul

Hi, I've done a bunch of research and am striking out here. I need to create a Delete Trigger. When the user deletes 1 or more rows in Table_A, I need to perform an Update operation on Table_B. But I need to retrieve the AutoNumber field from Table_A and do the Update on Table_B Where...

May I ask for your advice please ? I have a web page that does an automatic refresh every 5 minutes. If certain criteria are met it plays a sound. This works perfectly if the page is maximized. However, if the user minimizes the page, the sound will NOT play until you actually maximize the...