Search results for query: *

Is there any way to find which filed is the unique ID field in a table by using some type of SQL... i.e: select * from Test_Db..syscolumns c join Test_Db..sysobjects o on c.id = o.id where o.name = 'table_Test' The above example will find all column names for a given table. I m looking...

I have a page that connects to SQL server 2000 and executes a very large query, that returns a small amount of records. The query takes about 2 minutes to execute in query analyser but the ASP.NET page expires before i get any results on screen. The full message i get is: "Timeout expired. The...

I have a static multiselect list-box tbl1 which contains values. i m selecting several values i.e value1 and value2 and after clicking a button i want based on these selected values to create Dynamically (2) drop down boxes and append to them the values of my previous selection. So for...

does anybody know how to set the timeout command when connection from ASP.NET to otacle? using Dim oracleConn As OracleConnection = New OracleConnection oracleConn.ConnectionString = "user id=xxx;data source=xxx;password=xxx;" i tired connect timeout=9999 and connection timeout=9999 but both...

I am new to asp.net although i had a good experience working with ASP. I m connecting to 2 different databases, i.e Database A and Database B. Then Selecting fields from Database1.TableA trying to JOIN to Database2.TableB. I then bind to Datagrid. I used the folowing code which works fine but...

I m using MS Access 2003 and using the upsizing wizard i have migrated my database to SQL server 2000. Every time I use the MS Access's default search to search the recordsets of my database for a particular value on a large (10.000 recs) table, the search facility becomes very slow. I have...

Hello everybody, I am using Windows XP Pro SP1 with IIS 5.1, is there any way to allow a non-admin user using his accound (non-admin) log on to my machine and administer IIS i.e start/stop IIS server e.t.c lets say im the admin user and he isnt, and that we both exist on the same machine. In...

Can you help please? I have a text file ".txt" and i want to specify lines to read from it in command line. i.e my.txt contains Line 1 of text Line 2 of text Line 3 of text Line 4 of text Line 5 of text Line 6 of text Input Java LineReader 3,5 or Java LineReader 3 5 Output Line...

Hi everyone, could you please give me any possible links to a document/s (or anything) that shows or discusses or lists the basic (or detailed) differences of Access 2000 and Access 2002 (sp2). My attempt to answer this question was simply to go through some existing databases from others, and...

Hello I have just changed my partitions from FAT32 to NTFS but also installed Norton system Works. The problem i have is that the File system Object is not working partially since then. If i try to read drives it works fine: <% '***************** Drive Set fso =...

Hi everyone I recently converted through wnXP pro my FAT32 partitions to NTFS. I was using the following script to read files and folders for a shared area of my computer but after the conversion is not working. <% '***************** Folder Set fso =...

Hello everyone. I tried to use &quot; http://www.reneris.com/tools/ &quot; Image ASP component. Im runnin XP pro but the .dll cannot get registered and as i saw needs some other required DLLs (MFC70.DLL MSVCR70.DLL) but there is no reference of where to get them. I also tried Javascript but...

Hi everyone. Can anybody help me on how do i create an icon for my site so, when the users add it to their feavorites section they can have an icon instead of pure text? Typical example is the http://www.mydot.tk when you add this to your feavorite section within the links folder you will see...

Culd you please let me know any function that allows me to insert a new record that one of its fields must be something like the New records ID +(a Variable) I tried this but doesnt work: INSERT INTO pictures (bandid, production, picfile, piccomments, pictype, username, dateadded) VALUES...

Hello everybody. I am building a site that one of its facilities is to allow users upload directly to a predefined area of the server, which is within the main site subfolder in another folder. For example my site is /WebSite/UploadedImages/Image.gif Although the thing works fine for...

Hi everyone. I am building a web site on ASP and already used sessions. Although my users are people that have no knowledge of cookies e.t.c. All i want is a way of tracking users without cookie support and session objects... More specifically is any anyway to allow them log on to my site...

Hello everyone. Im a greek dude developing a site in one version for both greeks and english people. Im using ASP MS Interdev and MS SQL server 97. The problem i have is that when i do: select * from bands where band name like '%A%' i only get the english and all the greek characters goes...

Hello everyone. Im a greek dude developing a site in one version for both greeks and english people. Im using ASP MS Interdev and MS SQL server 97. The problem i have is that when i do: select * from bands where band name like '%A%' i only get the english and all the greek characters goes...

Hello people. Im doing a WEB type file manager, using the file system object, IIS, ASP and SQL97. All functions are working fine. Although the system can also handle HTML files. The problem i have is that every time im trying to Delete an HTML file that is been accessed by other users at...

Hello people. Im doing a WEB type file manager, using the file system object, IIS, ASP and SQL97. All functions are working fine. Although the system can also handle HTML files. The problem i have is that every time im trying to Delete an HTML file that is been accessed by other users at...