3,481 Topics
 | |
| | Hello! I have two tables in an MS SQL database that I'm trying to join and display through PHP. My connection is fine and I've done it many times before, so don't worry this isn't a PHP problem. It's a my-query-won't-finish-executing problem. Table A: (about 2 million entries) id | … |
| | Hello, there this is my first post and I´m desperate seeking for help, I have almost not knowledge of SQL as it is not my usual work. However, suddenly it has converted in mine....Hopefully I will got help in here. Well the issue is that our database manager has resigned … |
| | can anybody tell me abt the difference b/w sql server 2000 and 2005 |
| | can anybody tell me about the difference b/s a SP and functions  |
| | but i hope someone can point me in the right direction. here's the story 2 pc's, one upstairs with database one downstairs used to access and make changes to. This was working no problem for months. Then the downstairs pc needed a new AGP video card, easy install no configuration … |
| | [B][B]hi every body i'm new to MS SQL and i want to learn it if any body knows good source or web sites about sql server 2000, i'll appreciate if he lets me know thanx for your help, everunloaded, bye[/B][/B] |
| | Having trouble with Party POker and onli casino popups about every 2 minutes. Any help would be appreciated Here is the hijackthis log Logfile of HijackThis v1.99.1 Scan saved at 9:10:59 PM, on 1/7/2008 Platform: Windows XP SP2 (WinNT 5.01.2600) MSIE: Internet Explorer v7.00 (7.00.6000.16574) Running processes: C:\WINDOWS\System32\smss.exe C:\WINDOWS\system32\winlogon.exe C:\WINDOWS\system32\services.exe …  |
| | LOL - I figured it out - but thanks for looking :) |
| | I want to automate the file transfer from a remote site to my pc over a WAN. Can anyone please suggest an industry standard secure file transfer tool for a windows environment? I am looking for an industry accepted, more secure than traditional FTP. Thanks! |
| | can we write queries in functions I mean can execute queries in funcitons?  |
| | My name is Ralph. I stumbled on DANIWEB while looking for a solution to a problem. I must say I have browsed through other forums but is by far #1. I am somewhat knew to this Development life. I have programmed in VB.net for the last two years. PHP for …  |
 | I have a customer with a small accounting/invoice software program (order pro). Not very fancy at all. At any rate, the software stores all of the invoice data in one ".XDB" file. Anyone have any idea what type of database this could be? It seems like the application is an …  |
| | Hi new to the forum. I hope there is someone that can help me. I need to retrive some data from a table in sql server. The data is going to be used in an import to some other tool. The problem i have is as follow. I want to …  |
| | I have written a VB6 application to query an industrial MSSQL database and installed it locally to run on one network machine, Is it possible to install it on the server to allow all users to run it? Is the compile/build any different? |
| | Hey everyone, This problem I've been working with has got me stumped. Let me show you the table layout first. ID_NUM int, SEQ_NUM int, ATTRIBUTE_CODE char(2), ATTRIBUTE_DEF char(50), JOB_TIME datetime This table contains a list of activities individuals like and there is no way of knowing which one they like … |
| | The tables are joined. I want to display last 7 data with grouping their category My tables: Category: categoryId, categoryName Order: orderId, catgoryId, product |
| | Hello, Could you help, with sql injecton about from where i can download it and who it is works. plz  |
| | Hi I have question. When I post a thread, on focus of that thread, the brief discussion of that thread is displayed. I would like to know, how to develop that feature. Can some body help me out? |
| | Hello, I am having virus problems. My spybot search and destroy keeps finding and removing adware etc. and my symantic antivirus keeps blocking trojans and adware also. I keep geting popups, not even online, and I cant access the add and remove programs on xp. I did a scan using … |
| | i have a column "discription" in my item table that is full of HTML code. It was created using and editor like the one i am using here. It is five pages long when i print it out. I need to update the column in all records of the table. … |
| | Hi guys. I have a program which needs to store some user profile data. I want to use a database to do this, but i've never worked with databases. I was wondering if anyone can help me with it. My program is written in the java programming language, and i …  |
| | hi :) any comments appreciated about my site [url]http://extendedprocedure.com/[/url] |
| | Going back over the last 10 years of daily computing, it seems that around every 3000- 5000 hours of use my computer (there have been many ) reaches a point where anything it does is considerable slower then when a fresh install of windows occurred. Looking at my hijack log, …  |
| | Hi All, I have a software module(enquiry) developed in ASP using MSSQL as back end. In the index page , i display 4 new enquiries for the logged in user, clicking on which land to the enquiry pages. This has been working fine. But now recently i have come across … |
| | I've always heard it best to keep processes separate when dealing with Application servers etc. My question is this: [COLOR="Red"]Are there any best practices associated with creating a website that queries a SQL Database? [/COLOR] My thought is to separate the web element from the SQL Server and host it … |
| | Greetings Everyone, I am so glad i found this website, everyone seems very helpful and kind. 2 days ago i got a trojan/something that i thought Norton 2008 internet security cleaned. Guess not. after 2 days of cleaning...here's where i am. explorer.exe keeps restarting and stopping about 20 times, then … |
| | probably, all of you have seen this scenario a lot when entering customerID into a large database it takes AGES to bring back one simple record of a single customer === let's say, this has been DONE already , for tuning performance separate the CUSTOMERS table into 2 TBLcustomer1 -- …  |
| | Hi All, I have a software module(enquiry) developed in ASP using MSSQL as back end. In the index page , i display 4 new enquiries for the logged in user, clicking on which land to the enquiry pages. This has been working fine. But now recently i have come across … |
| | Hi. 7 days ago, we started getting redirected to arbitrary websites, our 'Windows XP Home' computer (with 6 separate profiles) suddenly got very slow, and we crashed alot. Norton Systemworks 2007 did not stop initially whatever hit us and could not remove it, but notified us of the presence of … |
| | Dear members, Please help me in regarding my problem. I am very much confused on whom to blame for the problem........MSSQL? or .NET ? or Win server? I have a dedicated server with 2GB RAM, SQL 2005, 150GB bandwidth, 160 GB disk space etc., I have created a .net application … |
| | Hello, im very new here. Dont understand the computers much, but can follow help step by step. Im using my Sony Vaio VGN-FS742/W notebook for some emails,store pictures and some common stuff. Im using comcast cable connections and it has McAfee security running for free. I have Ad-Aware SE and …  |
| | I am getting a server report from one of our companys sent to me and everytime its sent I try to open it in outlook and it says The page cannot be displayed An error occurred on the page you are trying to view. -------------------------------------------------------------------------------- To work around this problem, … |
| | company is using SQL version 7 to support heavy many ASP program last weekend, I try to upgrade it by installing extra SQL version 2000 (a software that company got) -- to try to aim for failover custer for the future then I can't find the enterprise manager console from … |
| | Recently had to re-install all of pc...not a prob as all (except db) was backed up to seperate hd. I develop locally using MSSQL client tools and adp's and then upload new tables as and when ready. I had done quite a bit of work when pc died, and now … |
| | Hi, Simple query: [code]select * from MyTable where Id=123456;[/code] The first time I execute this query it takes 14 seconds. However, the second time I execute it takes 0 seconds. I wanted to clear the cache so the second execution takes 14 second just like the first execution. So i … |
| | |
| | I need help to write a stored procedure, or pseudo code, that looks into a table named numbers_ranges and retrieves the next unused value. The table currently has the following data: Columns are: id, start_range (22), end_range (22), status (1), date_created (datetime), date_updated (datetime) 1 8057777777450780000000 8057777777450780000010 N 2007-11-29 16:28:46.793 … |
| | I am having trouble with the dns address on several computers that are on our network. They keep changing at will. If I do an ipconfig /renew it reverts back to the two addresses that are ment to be on the computers. I have found the computer that was causing … |
| | Hi, A third party development company is creating a third party application for us in PHP and uses a MYSQL database. The app is an extension of our website which is developed in .NET and uses a MSSQL 2005 database. There are some cases where the two databases require connectivity … |
| | Hi all, I'm currently finally starting mysql and am have difficulty getting it up online. what i've done so far is correct but only for this error: Warning: mysql_pconnect() [function.mysql-pconnect]: Can't connect to MySQL server on 'www.dteeducation.ie' (61) in /usr/www/users/adv123site/home/youruser/public_html//settings/database.php on line 10 Cannot connect to database, check if username, … |
| | Hi , Hey I have a small problem.... For a certain field in database, tha values are sent from front end(JSP page) . Each individual value must be extracted and then inserted into the database..... Before inserting, we have called a procedure which will extract each value and insert.... Moreover … |
| | Hi guys! I was wondering if comeone could help me with transferring data from one table to another. I am storing information of all customers who make an enquiry (PotentialCustomers) then transfering their details into a Customers table if they decide to purchase something from the company. How would I … |
 | I would like to know how to apply Constraints after creating a table. I was just practicing and creating a database HomeInventory by reading the free e-book from Microsoft. But I'm trying to implement the functions using T-SQL. So How can I do so? [code] CREATE DATABASE HomeInventory USE HomeInventory … |
| | We have a SQL server on a DL380 with 8GB of RAM and 2 processors. This should be enough to host a couple of databases. When I'm on the same LAN as the server (on the outside of the firewall) a select * from [tablename] returning 12000 records takes less … |
| | hi am raj! am a asp , sql server 2000 programmer i need a sql query to select unique rows based on noofcards,versionno,id here am giving the database ------------------------------------------- id email ccno vno nc ------------------------------------------- 41 [email]b@r.com[/email] f 2465 1 1 41 [email]b@r.com[/email] f 9898 1 3 41 [email]b@r.com[/email] a … |
| | Has anyone installed it? I've downloaded both express and full developer edition but I can't get past the user account stage. Can someone give me valid userID's and passowords for it? I don't have a password on my user account though.. |
| | hello there... i need help with cross tab query with sum(case actually iam using ms access 2007 and vb.net 2005 i have problems with the sintaxis ill paste the code below: TRANSFORM SUM(cantidad*(case tipo WHEN 'Entrada' else 1 then 1 end 0)-cantidad(case tipo WHEN 'Salida' else 1 then 0 end)) … |
| | Hello, would anyone be kind enough to help me tackle the ever-annoying Trojan Zlob-ad popping up every minute? I have completed several full system scans with Norton, a clean up and removed any viruses with Ad-Ware 2007. Only thing that was removed was a yellow symbol of an explaination mark … |
| | Hello, would anyone be kind enough to help me tackle the ever-annoying Trojan Zlob-ad popping up every minute? I have completed several full system scans with Norton, a clean up and removed any viruses with Ad-Ware 2007. Only thing that was removed was a yellow symbol of an explaination mark … |
| | Hey guys this is my first post! I was recently having problems with SpyWare Malware and so on, But I stumpled upon this site which helped me alot, My computer seems to be running fine but I wanted to post my HiJack and my ComboFix log so yall can check …  |
The End.