3,481 Topics
 | |
| | hello all, i want to save the web page content into a database. how can i fetch data from that website and save into a sql database. im using c# as front end. need help. expecting reply soon since it needed for my project. thanks. |
| | Hello I want to compare an inserted date against two stored dates in order to validate an entry. The date entered is being stored in a separate table from the stored dates. I am not sure how to go about this. So far I have this: [CODE]create PROCEDURE sp_GetTime @FullName … |
| | I've created an SSIS package where I have an FTP Task inside a ForEach Loop container. I am trying to loop through each file in the particular folder and send it to the FTP site. I am sure that I got the For Each Loop working, as the error message … |
| | i want to insert multiple int values selected from dropdown in to a single column seperated by a delimiter(,) along with this values there are some other rows too in which some other values are inserted a table has Booking id which contain values like 1 and roomid which contain …  |
| | Our employees have an interface to enter their vacation days. The vacation dates are stored in the database as one row per day, minus the weekend days. I'm trying to create a report that will show the starting and ending dates for each employee. Note: Each employee can have muliple … |
| | In my MS SQL 2005 i have given "[B]Windows Authentication[/B]". Now how to connect with NETBEANS?? I means wat to give in User Name and Password fields?? I tried to give my User name and password while login into Windows. But not working. I am getting this error [COLOR="Red"]"the user … |
| | Hi , can anyone help me. I tried to start an SQL Server instance from command line with sqlservr.exe. But on the last line it said "a significant part of sql server process memory has been paged out. this may result in performance degradation". And my instance didn't start. But … |
| | Our server growth is too fast from 30GB from last month now it reaches into 50GB. Is their a problem in our database? Can this be possible to shrink this database into a minimal Size? Our server is MS SQL server 2000. |
| | Hello, I have a little issue getting what I want displayed from a single table. Basically, here is what I am trying to accomplish. I have the following type of table: Place Action B/S Qty Type City Full B 1 View City Partial B 1 View City Partial B 1 … |
| | hi I am facing problem in connection of sql server in asp.net pages Actually there is error when i importing namespace [B]System.Data.Sqlclient[/B] [B] Error is:[/B] The type or namespace name 'sqlclient' does not exist in the namespace 'System.Data' (are you missing an assembly reference?) now i don't idea that what … |
| | Hello, I'm having problem with a query which is based on fixed-part and all I do is that I'm modifying part after WHERE something.value='... . This whole text is a string which I need to be connected to my query. '113') AND (reklamace.kod_reklamace = '932' ' Error message: Conversion failed … |
| | hello all, im a student and doing a project to automate a process. For which i ve to download files from clients site.. my doubt is can zip files be stored in sql database. if its possible means how can i achieve this.. need help! good day.  |
 | Hi guys , I am creating a timekeeping application to keep track of users. In my database I have a table which stores the time a user starts their break and finishes their break. I want to return the total time that the user is on break in minutes to … |
| | I am New TO Programming Am HAving 2 Table One Table Having Coloum ID and NAmeOf Eventt And Other Table Having Coloumn ID and Imagepath I want To Retrive Id related the NAme Of Event and Want To Insert That ID into other Table at the same time i want … |
| | Hello! I'm hoping that you can help me Alter a SQL table to provide a unique constraint over 2 columns. For instance let's say I have a departments table called Dpt_tbl with two columns that I want to be unique Name Location So I want to make sure that you … |
| | While I've been working with MySQL for years, this is the first time I've run across this very newbie-esq issue. Due to a client demand, I must host their website files (PHP) on a IIS server that is not running MySQL (instead, they are running MSSQL). However, I have developed … |
| | Hi, Not sure if this is right place to post this, please move if needed. I set up a web form so that the text from a set of text boxes was inserted into a database when you 'submitted' the form Since then I have added some validation to the … |
| | While i am installing joomla on my domain, showing the error Warning: in_array() [function.in-array]: Wrong datatype for second argument in D:\sites\frontpage1\parsuae\webroot\cominfo\installation\installer\models\model.php on line 453 What is this[code]Warning: in_array() [function.in-array]: Wrong datatype for second argument in D:\sites\frontpage1\parsuae\webroot\cominfo\installation\installer\models\model.php on line 453 Code Below, Please help me <?php /** * @version $Id: model.php …  |
| | General Question, no code: I have the daunting task of automating the import of mysql, ms sql and ms access into a central location. I've nailed the microsoft crap using ms sql DTS but even with mysql odbc drivers, cant seem to nail that one. The optional is that I …  |
| | Hello, can you help me convert MS SQL DateTime to miliseconds since 1970? Thanks, Domen |
| | DOH spelt thread name wrong... should be query! This is surely simple... this is the end of my query [CODE]where CCM0300.dbo.Device.tkModel= '72' AND CCM0300.dbo.NumPlan.DNOrPattern like '31455' OR CCM0300.dbo.NumPlan.DNOrPattern like '38600' OR CCM0300.dbo.NumPlan.DNOrPattern like '36305' OR CCM0300.dbo.NumPlan.DNOrPattern like '36805' OR CCM0300.dbo.NumPlan.DNOrPattern like '38285'[/CODE] what this is meant to do is return … |
| | Hi I need to create an SQL to retrieve the max date for each change in stock code. can anyone assist please? I am extremely new to SQl. I used access to get external data but it drags down 60,000 odd lines. i only have 5000 line items so with … |
| | Dear all, I am very new at SQL programming and are using the Microsoft Query to avoid alot of SQL programming, but I am stuck on one thing when I try to filter some data from the database... I want to show all delayed deliveries to our customers... Our Policy … |
| | hi i have a query and i want to use it in remote server when i try to run it in my machine it executes ok. but in remote server it cannot be executed. im connected to the remote server and i can view all the records in the table. … |
 | Just struggling through my SQL coursework, and already fallen over the first stubling block :( My case study tells me that i need to put a foreign key from my centre table (parent) to my salesman table (child) on a 1-1 relationship. Trying to add my foreign key, which is … |
| | Hi friends, I am new to SQL.. I have a table with 200 rows and 100 columns.. I want to extract unique rows from this table such that no two row are more than 60% similar.. this 60% is a variable and would be user defined.. I have attached an … |
| | Hi I am using ASP.NET to upload files that is to be stored in MSSQL Server 2008 as varbinary(MAX). I have issues with opening scanned pdf files once users upload them. The issue is happening very randomly (say 20% of the files cannot be opened .). It seems something is … |
| | Hy, Let's say that I have class Node with some parameters Node[] child's, string id, string content ... This class is like a another storage for data from mssql database. And that web-application is running on IIS server and is written in ASP.NET C# Now when one user open that … |
| | I have created a form in which there are various values such as Name, Address, Date of Birth etc. The user is also allowed to select an image in a picture box. I want to insert these values along with the Image into database in appropriate columns. Any help is … |
| | Hello I have 2 databases, one is like a backup for the other. So they have identical tables: Alarmi, which has columns: OBJEKT, OPIS, VREDNOST, START, E_A, UPORABNIK I want to compare those two tables and copy only new entries (rows) to the backup database. How can I do that? … |
| | Hello, I have downloaded "Microsoft SQL Server JDBC Driver 3.0" and tried sample code. I added "sqljdbc.jar" and "sqljdbc4.jar" in Libraries. But getting error, [COLOR="Red"]java.sql.SQLException: No suitable driver found for jdbc:sqlserver:bug_tracking at java.sql.DriverManager.getConnection(DriverManager.java:602) at java.sql.DriverManager.getConnection(DriverManager.java:185) at Main.main(Main.java:18)[/COLOR] The code is given below : [CODE]import java.sql.*; public class Main { public … |
| | Hi friends.When I try to connect to sql server 2008 from visual studio 2008 an error occurs : "A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL … |
| | I am creating a sample database and the work is so painful, I really wonder and need assistance to reduce my pain. I would like to create a "lookup Field" which returns the value (string) automatically from another table. Example, I have 2 tables - Department and Employee Department[DepartmentID, DepartmentName] … |
| | web.config ConnectionString My Connection string for an application within iis to connect mssql db looks like this <add key="ConnectionString" value="server=localhost;database=search_parser_2;uid=DOMAIN\Administrator;pwd=password;Connect Timeout=1000000;" /> Yet the application wont get past the login script (where the sql connection is happening i presume). the database name is correct and the server name is correct … |
| | What I'm working on is a video rental project in visual basic 2008. I have a local database which contains info on DVDs, Members and a table for current rentals. [B]The columns i have in the current rentals table are:[/B] MemberID | DVDID | DaysOnRent | DateRented | DueDate | … |
| | I have 2 databases on my computer, managed in the same SQL Management Studio - named [B]DATABASE1[/B] and [B]DATABASE2.[/B] The two databases are different except they have 1 table is the same, this table is called [B]Employee[/B] Because this the content of this table should be the same, how could … |
| | Hello Everybody, I have used inner join with two tables to join them and tried to calculate the sum of rows. Now the table descriptions are- Table1- agent_business_collection (it stores business collection of an agent of different business packages) Table2 - agent_business_commission (it stores commission of an agent against different … |
| | I am exporting a large amount of data from SQL Server 2005 to Excel. Most of the data appears as I want it to- without the exponential notation. Any values [I]smaller [/I]than 0.0001 (i.e. four zeros to the right of the decimal) are displayed as, for example, 7E-05 rather than … |
| | I need to have a database of the online flight booking system. May i have some guidance ? |
| | Hello guys help pls i'm trying to populate data from MS Database to list-view [code] string Collect_FULL = "SELECT FirstName, MiddleName, LastName, " + " Gender, DoB, Dependents, Address + ', ' + City + ', ' + State + ', ' + ZipCode AS Address, PhoneNumber, MobileNumber " Status … |
| | I was searching around but I could not find it: I'd like a tool(free or paid) that is able to manage multiple MySql servers from the same GUI. I know about few thick-client apps that do this, but I need one that you can use it from internet. So far … |
| | was using c# to develop some application and wanted to connect my application(windows) with SQL database. using sql 2005 express and visual c# express; but it kept on throughing the following exception while i try to run my app. so help me out "An attempt to attach an auto-named database … |
| | Hi All, I am trying to convert the following access update query into TSQL without any luck: UPDATE tblCattle INNER JOIN tblFarmDetails ON tblCattle.strEartag = tblFarmDetails.EarTagNo SET curMartPrice = tblFarmDetails.MartPric WHERE (curMartPrice=0 Or curMartPrice Is Null); First I tried simply pasting in the query with no luck so below is … |
| | I need to eliminate a record with almost exactly the same data except 1...for example: I have 4 Fields for Employee table: Employee Stat First Name Last Name Employee ID Active James Smith JOS Resigned James Smith JOS For some reason the table I'm querying has these data. How can …  |
| | I have a problem I have a long table with many costumers, each costumer have between 70-100 bills how can i get for each one his top 5, all the replies giving me only the top 5 of the first.(MsSQL!) 10X Ofir |
 | Hi I Create the tigger when update process happen in database.When the after update process happened ,tigger instert the new record into another table about that table locate in different server.I create linked server also ,once tigger execute it generate the Error message .Below I mention the error Message I … |
| | The site that i'm working on is [url]http://www.perfectbrewingsupply.com[/url]. The site seems to come up properly (after i reset a new user/pw in the config file) but when trying to access the database for zencart, i am still receiving the following error: 0 DB_ERROR_NOT_CONNECTED in: [select * from project_version WHERE project_version_key … |
| | Hi guys, I have a problem when synchronizing web publication. I begin by giving you an insight into my soft installed: -sql-server 2005 -windows seven so IIS7 I created a publication MaPublication.I made a right click on publication-> Release Local> MaPublication then I chose to configure synchronization Web.Then, next-> sql … |
| | I Got 2 tables: 'Standby' and 'Usage' [COLOR="Red"]Standby[/COLOR] Table got this fields: [COLOR="Red"]PartNº[/COLOR] (equipment id); [COLOR="Red"]Area [/COLOR](physical location); [COLOR="Red"]Stock1[/COLOR] (Nº Total of equipments); [COLOR="Red"]Usage[/COLOR] table got this fields: [COLOR="Red"]Quant_Used[/COLOR] (The times that the equipement is taken from Standby); [COLOR="Red"]Quant_Received[/COLOR] (The times that the equipement is restored to Standby); [COLOR="Red"]PartNº[/COLOR] (foreign … |
| | hello all in table1 I have Date Value 2/1/2010 100 2/2/2010 110 2/5/2010 95 3/4/2010 150 3/15/2010 220 etc how to sum the value according to it's month ? so I got Pebruary' sum value=315 March sum value =370 tq |
The End.