6,934 Topics
 | |
| | Hello, I am trying to analyze 56 years of hourly rainfall data. Right now i have three columns. Date(mm/dd/yyyy), hr(0-23) and hourly Rainfall(inches). I would like to know the count of rainfall events that exceed 2.4 inches in 24 hrs. Meaning if the sum of Rainfall exceeds 2.4 inches in … |
 | Hi I have no experiance with vb6 and databases, but I do have experiance with mysql and php... I wanna make a game with vb6 and retrieve the user info from my sites database. How do I connect to the database in vb6. A tutorial would be nice. |
| | Can someone show me what to do to get a query to run with persisence? [code] private void searchJComboBox1ItemStateChanged(java.awt.event.ItemEvent evt) { if (searchJComboBox1.getSelectedItem().equals("by Artist")) { String holdQuery = searchJComboBox1.getSelectedItem().toString(); setSearchInput(holdQuery); //searchJTextField1.setText(getSearchQuery()); } if (searchJComboBox1.getSelectedItem().equals("by Song")) { String holdQuery = searchJComboBox1.getSelectedItem().toString(); setSearchInput(holdQuery); //searchJTextField1.setText(getSearchQuery()); } } @Action public Task searchSplash() { if … |
| | My application runs on a network of 15 to 16 clients on a SQL Server 2000. Some of the modules perform transaction, i.e. they run more than one sql. I have tied the different sql statemels under the following procedure: <code> con.Open() trans = con.BeginTransaction() Try ‘First Sql cmd = … |
| | Hi, I succesfully installed Sql Server express 2005 in my lap top . I'm using Windows Vista Premium. However I was not able to do anything my permissions were messed up I tried to add me as a db creator, db admin but Sql wouldn't let it displayed an error … |
| | I have a database called "App" and a table called appinfo. I am able to connect to the database. It has only two entries since I am just trying to learn how to use php and sql together. The first column in the appinfo table is called [B]ID[/B] followed by … |
| | i create a form that user can enter their data then save into SQl server...that problm have being solve... Now i want the data to be automatically appeared in the text box and user can use the next button to search for their data..(text box created early for the user …  |
 | Hey, I am currently having some problems with VB.net and MSSQL. I'm trying to create an application to learn more about VB.net, I decided to create a simple login system for the application (like the ones they used in distributed applications which have a centeral SQL server). I have come … |
| | |
| | I want to make a server authentication login. First I logged in with windows authentication, changed the server authentication from windows authentication mode to sql server and windows authentication mode. Then I created a login, named it jihad and changed the password for that login. Then I gave that login …  |
| | I'm trying to update multple queries but the update is not working. here is the code.... [code] if (isset($_POST['btnSub'])) { // Preset counter $p and switch $sw to 0 $p=$sw=0; // Create UPDATE queries foreach($_POST["entry"] as $data) { $sql[$p]="UPDATE major SET "; foreach($data as $key => $value) { // Save … |
| | Hello!!! I want to make a web site, and first I want to make the log in page using Login control from ASP.NET and I want to take the users from a database. Thanks for helping!!! |
| | Hi, can anybody shed any light on what I'm doing wrong here... I'm trying to acheive an XML that looks like the following: [code] <tshirt Name="Stussy NY Posse T-Shirt Yellow"> <variant size="small"> <productID>10</productID> <dimensions length="34" /> </variant> <variant size="medium"> <productID>11</productID> <dimensions length="45" /> </variant> <variant size="large"> <productID>12</productID> <dimensions length="50" /> … |
| | I recently purchased Visual Studio Pro '08 and installed in on Vista HP. It comes with SQL Server Developer, but I disovered I could not get that to install correctly. From what I have discovered on other forums, Vista HP does not expose IIS properly to SQL Server so Reporting … |
| | Hi All I am new in development I want assistence in database design (asp,sql server) for crm schedule calender . If you have any sujessions or link, i will like if you post them |
| | Suppose a table ABC have column XYZ containing data 3PSY0001-06-08-F 3PSY0001A-07-09-P 3PSY0001-02-09-P 3PSY0001-07-07-F 3PSY0002-09-08-P 3PSY0002A-01-03-P 3PSY0002-07-07-F How can i write a query so that the data ending with P without A can be updated with A. For example, with that query, data 3PSY0001-02-09-P AND 3PSY0002-09-08-P will be updated as 3PSY0001A-02-09-P … |
| | hello is this how u do a delete query from mysql table i need to delete it depending on id number so if user enters id 10 it needs to delete the all the rows that have id 10 from any table which has that id.. thanks $query = "DELETE …  |
| | Hey all, Ok first my problem. I have a database that has an employee table and then also an absent table(for when they are off sick). The problem i have is using sql to find the employee that is off the most! So for my sql on the absent table … |
| | Hi, I get the following exception when i try to run the following code segment. [code=JAVA] stmt = (Statement) conn.createStatement(); rs = stmt.executeQuery( "SHOW TABLES"); if(rs.first()) { stmt.execute( "DROP TABLE " + rs.getString(1)); while (rs.next()){ stmt.execute( "DROP TABLE " + rs.getString(1)); } } [/code] And the exception i get is: …  |
| | hi members,just asking if anyone has an idea of connecting a vb form to a my sql database.please i need your help.thanx  |
| | I have production data on one server and test data on another. I need to move one record from the production server into the test table on a different server. I setup the production server as a linked server one the test box. I can read/select fine, but when I … |
| | Hi, I have a project which requires me to use PL/SQL blocks, PL/SQL cursors, PL/SQL stored procedures, PL/SQL stored functions and PL/SQL triggers. I think(not sure) i can create PL/SQL stored procedures, PL/SQL stored functions and PL/SQL triggers in MySQL. Can i create PL/SQL blocks and PL/SQL cursors within MySQL … |
| | I'm trying to install SQL Server on a Vista HP machine, but it will not detect IIS, which in turn prevents Reporting Services from being installed. I have seen blogs which indicate that the UAC system in HP does not properly detect IIS and that as a result NOTHING can … |
| | I want to get two columns data from two tables which are not dependent to each other i.e. no key common in both they are not related to each other. I can't use JOIN because it needs where clause which uses a common field from both tables. I just want … |
| | steps i Follow- 1) Go to Control panel-->Admintrative Tools-->Double -click Data sources(ODBC)-->click Add button-->I choose SQL server(last option), Is it right or wrong option for connecting to SQL 2000.Then a new screen appears Create a New dataSource-->in name textbox,we can write anyname--Right or wrong. suppose i enter sonia, & my …  |
| | As the spyware itself ironically keeps reminding me, my computer has been infected with the classic "big red circle with a white X on the taskbar" virus/trojan/whatever program. My numerous attempts at killing it with tools such as Spybot and CCleaner have all failed, and I must now rely on …  |
| | Friends, I recently switched to SQL server 2005 from SQL server 2000. Well in SQL server 2000, I used to made databases manually and applied other SQL commands from Query Analyser menu. Where's the same functionality is provided in SQL Server 2005 . Where's the path to go there? Waiting … |
| | Hi , First post in this forum and hope this is the right area: Website crashed and am rebuilding from scratch. Basically an ASP site, Data driven by SQL Server 2000 running II6 on Windows Server 2003 SP2. Problem is that any URL links that are generated from a stored … |
| | can anyone tell if it is the right way to connect these tables? What is the query display customerid, b_customer_id, and h_customer_id... thxxx --customers [code=sql]drop table Customers cascade constraint; create table Customers( Customer_id Number(5) primary key not null, Credit varchar2(20), Street varchar2(20), City varchar2(12), State varchar2(2), Zip varchar2(5), Telephone varchar2(14));[/code] … |
 | Hi , Can any one tell me the Optimized & fastest way of taking backup & restoring my database that is in SQL Server through C# code. Currently I am using SQLExpress .Is there any Better approach of achiving the same? Regards IT_Techno |
| | Hi I am hopeing someone can help me with extracting and formating the time from an sql server datetime field. I have tried a number of different methods, all of which have returned a runtime error of 800a000d. The following are two methods that I have tried, yet I think … |
| | Hi, I have two datadase one one local system and another on web Both of them are on SQL 2005 .Now I want to make a link server to have connection from both database to transfer data . plz give me some link or code. thanks  |
| | Hi, I have problem when trying to connect to databse and execute query. Here is the full code: Private Sub OpenDataReader() Dim strConn As String = "Server=localhost;Database=Northwind;" + _ "Integrated Security=SSPI" Dim cnnNwind As SqlConnection = New SqlConnection(strConn) cnnNwind.Open() Dim strSQL As String = "SELECT * FROM Shippers" strSQL += …  |
 | I have a bunch of print statements in a SP that tell me exactly what went wrong in the SP (if anything), but I cannot figure out how to capture the text in the [code=sql]PRINT 'Receiver and Customer don''t match'[/code] statements... I pretty much want to get the info with … |
| | Mhm. This is the VB.net code behind a webpage I'm working with, I've also provided the ASP.net for the frontpage as well. This maybe really simple and I've missed it but everytime I run this code (below) I keep on getting the same error "Invalid column name, Skyrail" where 'Skyrail' … |
| | Hi all, i need help on asp-sql code. I have a form when I catch some infos and i want to create a new record into a database. I have tried many syntax but I can't pass the variables a,b,c,d,e,f to sql string. Please tell me how can i do … |
| | ASP & VB with MS Access. This recordset should spit out the results of a search from several select boxes on previous page. I keep getting: [QUOTE]Error Type: Microsoft VBScript compilation (0x800A03EA) Syntax error /RP_Ref_Guide/RP_search_results.asp, line 25 IF fRPname <> "" THEN results1=results1 &" WHERE tbl_Partners.Partner_company = " & fRPname … |
 | How do I insert variables with data type as DOUBLE? like in the code below, it is how you insert strings into mysql [CODE] myconnection->myquery->SQL->Clear(); myconnection->myquery->SQL->Add("insert into users (user,pass,email)"); myconnection->myquery->SQL->Add("values ('"+user->Text+"', '"+pass->Text+"', '"+email->Text+"')"); myconnection->myquery->ExecSQL();[/CODE] in this statement: [CODE]myconnection->myquery->SQL->Add("insert into users (user,pass,email)");[/CODE] user, pass and email are fields of users table, … |
| | Hi All Im having issues with my mail command sending data from my script. I have a korn shell script which logs onto a database and does a few select statements. The problem is i think the EOF stops my mail command sending the data. Im able to run the … |
| | I have a program that creates a SQL statement based upon a treeview list that the user makes. The SQL statement looks like this: [code]CREATE TABLE Test ( Test ID PRIMARY KEY, Check1 CHAR(255), Check2 MEMO, Check3 INTEGER, Check4 DOUBLE, Check5 DATETIME, Check6 BOOLEAN) VALUES (1, 'DefSML', 'DefLRG', 0, 0.0, …  |
 | I have been using VB.Net for a little while now, but I just started needing to write code to put information in a SQL Server database. I have two tables that I need to add information into. I know that I have to use an Insert statement, maybe I need … |
| | hi everyone. I am doing a project in jsp where i need to check the duration of logins of a particular client. If the client doesnot login for 6 months(say) his account should expire. For this purpose i am taking system date and storing it in sql database. I have …  |
| | hye there..i need help here..im developing a smartphone device. i need to install a sql server ce but somehow i download it,but i cant run application.so my ques is how do i know wat the version of my sql server 2000 (version 8.0)competible wif which sql server ce? thanks in … |
 | Hello everyone! I am writing a music database, and I need to insert into album table the path to its cover. However, not every album has a cover in its directory, so I've made an algorithm that only gets the albumID that has a cover. My question is - how … |
| | Hi guys, Another Vista restart problem. This SQL writer restarts Vista atleast once a day. The even viewer has this to say: Product SQLWriter Problem Service Hang Report Date 26-03-2008 AM 10:53 Status Not Reported Description Service SQL Server VSS Writer hung on starting. Problem signature Problem Event Name: ServiceHang … |
 | how to calculate rank in selected record set in sql server 2000 can u help me? |
| | hi i am using sql server 2003. can we get the position of record / row index in sql server while retrieving records? like in some case we fetch records as per our criteria. And if that time need to know the postion of particular record then? how to get … |
| | I have a table having columns like values, like this col1 col2 col3 1000 10 2 1000 20 3 1000 30 4 2000 10 5 2000 20 6 2000 30 7 3000 10 8 3000 20 9 3000 30 10 I want to fetch records like if i enter col2 … |
| | Greetings, I'm using Flash MX connecting to an MS Access database via JET. I've stored dates using Flash/Jet into my database as 'dd/mm/yyyy hh:mm:ss' into a DATE/TIME field. However I can't update because of the WHERE clause as I am not specifying the date correctly. I believe syntax wise I … |
| | Hi, If someone can help me with this I'd really appreciate it! I installed SQL Server 2000 Standard Edition on Windows Server 2003. This server is due to take over from our present Windows 2000 Server. It was my first time doing a SQL install, so I ended up calling … |
The End.