6,934 Topics
 | |
| | Hi, we are shifting our data-setup from SQL Server 2000 to SQL Server 2005. With regard to this, I am facing an issue with replication of the databases. We have a database with over 600 articles that are published. The procedure that we followed with SQL Server 2000 in order … |
| | Hi all, I have managed to get my average using cross tabs but only if I have grouped it by their categories. If I remove the GROUP BY clause, the cross tabbing doesn't seem to work. Can anyone help me? I would need to get something like:- [CODE]Year | Month … |
 | |
| | I am a SQL n00b, mostly using some hand-jammed ASP to access/update data. Now I have been tasked to develop a web map of our campus so I need the geospatial functionality of SQL 2008. I have a server (Windows 2003) that is limited by domain policy. I tried to … |
 | hallo there. i am new in programming so i ask for your understanding i want to put the results from a sql query into a textarea. then i want to be able to pick one of the records of textarea and delete it (textarea and database). (i dont have to … |
| | Hi I have a problem when I am copying data from my excel document to sql server 2005. I have a document called database.xls Every time I try to copy files from the document to sql server. It comes up with an error. "Column 'tid' does not allow DBNull.Value." You …  |
| | OK, I'm new to PHP and SQL so you'll probably have to explain most tings in laimen terms! I have created a website with PHPMaker, a kind of loaning libary where stock gets loaned out and out and then returned. Now it works all ok, however I want to be …  |
| | I have a webserver in a data center that has to connect to my sql server here in my office. Right now I am using Windows dial up vpn which works fine performance wise. The problem is if i log off my web server the VPN disconnects is there an … |
| | I need to connect my hosted vps in a data center to my sql server so I can pull info out of a database for our website. I setup a vpn by the windows dialup vpn wizard. It works fine but when I logoff the VPS it disconnects the VPN … |
 | Hi We have got a single instance of SQL Server 2005. The latest service pack 3 has been installed today. Since installing SQL Server two months ago we are finding that SQL Server times out if you try to delete records from any table that has more than 600,000 records. … |
| | Hi, Using VB 2008 Express with Compact SQL .sdf database. I have a form that at form load fills the form with a single record as selected by double clicking row header on a datagrid. This works fine. But when I change a field and hit the save data button … |
| | Hello. I'm burning my head on a problem with a query. Querying a payments table, I need to find the actual membership category (let's say: IDCATEGORIA). If I run this: [code=sql] SELECT idpersona, idcategoria, datapagamento, datascadenza FROM personacategoria WHERE NOW( ) BETWEEN datapagamento AND datascadenza ORDER BY idpersona, datascadenza [/code] … |
| | I am trying to figure out how to do multi-threaded and asynchronous programming in VB.NET. I am trying to write an application which has a list of .sql files (some stored procedures, some regular t-sql code). These reside in a directory and get read in and processed. The idea is … |
| | Hi, I am trying to copy som data from an excel document that I have on the server into a table in my ms sql server. I think the problem now is that I am having trouble connecting to the sql server. I'm using sql server 2005. You can see … |
| | I'm using the Brinkster control panel Database Manager to investigate a database on a site I just took over. I don't know anything about the database. I tried a SHOW TABLES and got an error. I also tried SHOW ALL. Do you think I need a ; after the command … |
| | I would like to do an Audit of who Prints out my Page of the Top Frame. I have the audit code figured out but I would like to know if there's a way to Press the print button and Print the Page. If the page was successful printed I …  |
| | I've a form like newform1 and a table newtbl1... in form I've a unbound checkbox "chkbx1" and in the newtbl1 i have a field name chk_stat which is a checkbox (yes/no) now i want to link this chkbx1 with the chk_stat. mean when i check/uncheck checkbox1 same thing happen in …  |
| | Hi there, I pulling my hair out with a SQL statement I am using for a query in Access. I have a list box which pulls data from my table. I am using the list box to allow the user to select a record which will then be pulled up … |
| | hi, how to retrieve data from SQL database into a combobox in Visual basic 6 |
| | Happy Holidays! I have a one field form. Upon submission with the submit button, I wish to drive this field value into my SQL database table called MEMBERS and field called NAMES, thus adding a new record. Can this be done with an OnSubmit() call to a function, in the … |
| | hi frd, how to fill value on a specific column of a table by c# |
 | Hallo to all, I have a problem in connecting to MySQL Database on my VB Program. "Can't connect to MySQL Server on 'localhost' (10061)." This is the error I always receive, what seems to be the problem? can anyone help me? |
| | hi, i have one table called EMP with 3 fields SSN,ENAME,MGRSSN. query to retrieve all employees name and their respective manager names(only using this table no other table and ssn primary key. i know till here.. [code=sql]SELECT ENAME,??? FROM EMP WHERE SSN=MGRSSN ;[/code] here im only getting manager's name..so how … |
| | Does anyone know if it is possible to save a document to a SQL 2000 database image field from a .NET web form running on Windows 2000 .NET 1.1 framework. I've seen plenty of code on the internet on how to do this in Visual Studio 2005 and .NET 2.0 … |
| | Hi, I wanted to issue a select query with where clause. I used sql parameter in my sql query, but how do i pass the value to that parameter at run time. Help!  |
| | Hellow evey body, I have to use same sql query frequently on diferenet php scripts pages in a appliction, i want to put this query in a funtion to use it where i want but this funtion is not working at all. i am unable to figure out the problem, … |
| | Ok, I'm having a big problem with an sql string for a query. I want to implement a methode that allows the user to search for hotels by entering the minimal price ( so if they enter say 20 it will only display hotels that have prices above 20 ). … |
| | Hello all, lets say i have a table like this which has 3 columns and 3 rows; -----------------------------------------------------------+ COLUMN_A.....|.....COLUMN_B.....|...COLUMN_C | .........X............|...........X............. |.........X...........| .........X............|...........-...............|.........X...........| ..........-............|...........-...............|.........X...........| -----------------------------------------------------------+ So, now i have an input like; (user submits a form) ----------------------------------------------------+ ......X............|...........X............|..........-.......| ----------------------------------------------------+ now; the first column of row#1 is X so it is … |
| | Hi I'm having trouble with a subquery and really need some help. I'm trying to count to count the number of beats sold by a particular producer. So the first thing I did was SELECT all the beats sold by that producer so I wrote the code [CODE] select name, …  |
| | Trying to dispay an error message if the varibel does not exists. In my sql database the variable is a blank cell or data. [code=coldfusion]<cfoutput><cfif #findorder.email# eq ""></cfoutput> Display error message here... <cfelse>[/code] It will not display if the cell is blank but it does work if there is data … |
| | was directed here by another member...great site! (am a newbie and I recently posted this on MSDN with 0 replies, am hoping someone can help here - you do not need to know VFP, just need help formatted a correct string that ASP will honor), Current Setup: Using: Visual Web … |
| | Hello, I'm using VB6 and SQL Server 2000. I've got a problem with an insert statement that seems to be randomly failing. Its job is to copy everything from one table into another, removing duplicates using WITH IGNORE_DUP_KEY ON [PRIMARY]. Then my code copies the records back to the original … |
| | Please fellow programmers am relatively new in programming and am currently working on a Library Maintainance and Administration software and am finding it hard inserting pictures with other data's into the database The picture insertion should be optional.Please i need to know the codes i need to achieve this Please … |
| | Hi all, I am working with a project which includes Crystal Reports in Vb.Net and SQL Server2000 as Back end. The code in button click is [code] str5 = "D:\AttendanceReport.rpt" If Not IO.File.Exists(str5) Then Throw (New Exception("Unable to locate report file:" & vbCrLf & str5)) End If str6 = "SELECT … |
| | Author Table INSERT INTO Author VALUES (12,'James Smith' ); Using join conditions Find memebers (by name) who have ever borrowed a book written by certain authour (JAMES SMITH) |
| | Hi friends, Please someone how to create a dll in vb. net class library , how to register it and how to call it using sp_oacreate. Pls provide some sample codes. |
| | Have made DSN, Now i want to make connect to database.. want a vb script for this. have to fetch data from data base Somebody help please. |
| | Hi all, I have this sql line (below) and where it works fine at the moment. But I have columns with 2 words i.e. opened by. I would like to add this colum to the statement below but everytime i try it errors. Do I have to reword the statement … |
| | Is it possible to call a sql view in vb.net? I can call stored procs, but when I change the code to read a view it says that "request for procedure failed because it is a view object"  |
| | Hi all.. dis is kinda urgent case though coz i dun have much time to complete my final project.:'( I've installed sql server 5.0 and the connection is on.I have also created the tables related to my interfaces As for vb.net, i've finished with all my interfaces. Now, the problem … |
| | The class should support a function named Profiles which takes a ID as an Integer parameter and returns the name corresponding to that ID as a String. If the name is NULL, then the function should simply return an empty string (String.Empty). If the ID does not exist in the …  |
| | hai friends, i am developing a application like a job portal. but in that i am getting a error whilw i am writng the program.. please clarify my doubt.. the error is: please tell me the how to delete a record from database using asp .net and C#. please send … |
| | i have customer details in my sql database. then i have a textbox, combobox & button. if i type customer name in a textbox i should get his id in combobox. if there is more than one customer with same name that id also should fill in combobox. i need … |
| | |
| | i am developing a job site and i require to search for records from the database. i m passing value fro that parameter in textbox. so please help me thanks in advance |
| | Please friends am working on a project in which am trying to make it possible that when the first letter/alphabet of a name is keyed into a textbox linked to a search button and when the search button is pressed, all the names/rows begining with that first letter will appear … |
| | i have table A with coloum f1 and table B with coloum f2...want to combine these to 2 coloums and make coloums f3(f3=f1+f2) can anyone tell me the query for that ... |
| | pls help job at stake!! An image is stored into database using delphi with a back end Access.This images were imported into sql server.Now i want to display the image using vb6.Please help with the code  |
| | Hello, I have question about backup and restore procedure for MS SQL 2000. If I make a full backup on Saturday and Transactional backup on Sun - Friday. When restoring I know sequence matters but what if I make a mistake and select transaction log out of sequece to restore. … |
| | Hello, I am trying to setup log shipping for SQL 2000 database. I don't see option to "specify the transaction log share". According to MS Log Shipping instruction, "specify the transaction log share" screen shows up if I have specified that the plan will install log shipping. Where do I … |
The End.