6,934 Topics
 | |
| | I'm pretty much a newb when it comes to PHP and MYSQL (taught myself, so I make a lot of mistakes :confused: ) So here's the code... [code] $query = "SELECT DISTINCT(t_tag) FROM tags ORDER BY t_tag desc LIMIT 50"; $results = mysql_query($query) or die(mysql_error()); while ($row = mysql_fetch_array($results)) { …  |
| | i am asp.net beginner , i need to upload file to sql server 2005 and also download file. what are the code to use and where i put the code . plz ... |
| | Hi, I'm new here, and still a noob in sql. This is my query [code=sql] SELECT Payments.ClientID, Payments.CreditorID, Clients.FirstName, Clients.LastName, Clients.SSN, Clients.Address1, Clients.Address2, Clients.City, Clients.State, Clients.ZIP, Clients.HomePhone, Clients.WorkPhone, Clients.OtherPhone, SUM(Payments.Amount) FROM Payments INNER JOIN Clients ON Payments.ClientID = Clients.ClientID WHERE (Payments.CreditorID = 1015 or Payments.CreditorID= 1014) GROUP BY Payments.CreditorID, Payments.ClientID, … |
| | Help me with the code or tutorial on how to connect vb .net with sql. dbase. thank you  |
 | I dont know where I post this question.,anyway i run sql statement in C#,but once i run my applcaiton it gives me error message .It says [COLOR="Red"]incorrect synatx near keywork 'AND'[/COLOR] this is my sql statement. string str1 = "UPDATE dbo.Retailer SET SalesExecutiveCode='" + this.comboBox1.Text + "'" + " AND … |
| | I am receiving an error stating that there was an unexpected failure during setup wizard and to review setup log when trying to download sql server 2005 from microsoft eopen on a windows 2003 server. In the log there if reference to Failed to find property "watsonFailedActionErrorCode" {"SetupStateScope","",""} in cache … |
| | I set up a server with SQL 2005 Standard and another server with SQL Reporting Services. Now my boss wants to upgrade to SQL 2005 Enterprise Edition. What would be the procedure for this upgrade and any caveats or problems that might arise, not only with SQL 2005 Std to … |
 | I am trying to install Microsoft Accounting 2008 Express, which requires installing SQL Server Express 2005. I have a Vista Home Premium machine and it's giving me fits trying to get SQL Server (any flavor) installed. I've tried every tweak I can find online, but all to no avail. I've … |
| | How do you use sql 2008 express edition with html to create a website. I'm using a domain service through yahoo to build the website. I want to make it a multi page site with video and audio. |
| | hi, :p i am trying to achieve a registration page in JSP. i am using tag library to do this. c tag library and Sql tag library. [CODE] <%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql" %> <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %> <c:if test="${param.submitted}"> <c:if test="${empty param.name}" var="noname" /> <c:if test="${empty param.pw}" var="nopw" /> … |
| | Can anyone help me on this I recently installed MS SQL 2005 Developer on my PC (XP Pro)and that works oK. I installed another on my Notebook (Vista Ultimate) and somehow got connected to my PC Database. But that is cool. At least I know I can connect to my …  |
| | Hello I am new in this. Just installed MS SQL 2005 on my notebook for learning purpose. I found that though using the default instance, it keeps giving me a logon screen which I am having problems loging in with Server Name: JMZCONS-PC Error Number: 18456 Severity: 14 State: 1 … |
| | i tried to add a database file to an exsiting Website project. i get this error. "connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly." installed products are visual studio 2008 sp1 sql server 2008 however creating a data connection to a database attached with … |
| | Hi all, I need a help in MS SQL Express query. I have a table named "tblTotalCust" and the fields are: [Date] date, [ServedTime] date, [TotalCustomer] int. Example data: [Date] [ServedTime] [TotalCustomer] 8/9/2008 12:00:00AM 8/9/2008 9:23:00AM 12 8/9/2008 12:00:00AM 8/9/2008 9:27:00 AM 7 8/9/2008 12:00:00AM 8/9/2008 9:37:00AM 9 8/9/2008 12:00:00AM … |
| | Hi i've got a problem. I keep getting this awesome error "[Build Error] [Project1.exe] Error 1" I copied this source code from [url]http://www.daniweb.com/forums/thread56924.html[/url] I just can't seem to get it to work. can someone pls help [CODE]#include <windows.h> #include <stdio.h> #include <string.h> #include <odbcinst.h> #include <sql.h> #include <sqlext.h> #include <sqltypes.h> … |
| | Hi all, I am trying to extract some records from a SQL Server 2005 database and insert into a MySQL database. The extract from SQL Server must also be captured as an XML file. I want to call this from a button. Unfortunately, I have not been able to do … |
| | Hi I've used Access to model a new database that now needs to be created in SQL Server Express. Wow - that's alot of data types! Can someone tell me what the SQL version of the Access Memo data type is? Thanks _________________ [url=http://www.freefixit.net/monitoring-parental-control-software-advice/]Parental control software[/url] [url=http://www.loans.cc]free parental control software[/url]  |
| | i want to create a table in sql database using php code. if i try to use the sql command(given below) in my php source code [code]"CREATE TABLE new_table( id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT, id1 VARCHAR(55) NOT NULL id2 VARCHAR(32) NOT NULL, id3 CHAR, PRIMARY KEY(id));"[/code] i get syntax … |
| | I am currently using the ODBC class for c++ to connect and query a SQL database. I am calling a stored procedure within the database like so: [code=cplusplus] try{ myCon->Open(); OdbcCommand^ myCmd = gcnew OdbcCommand(MySP,myCon); //MySp is my store procedure and myCon is the SQL server connection string myCmd->Parameters->Add("xml",OdbcType::Char,200); myCmd->Parameters->default[0]->Direction=ParameterDirection::ReturnValue; … |
| | Hi! I have created a web form with HTML and ASP (separate but same idea). What I want is that this form will be autofilled with data from Excel spreadsheet or alternatively from ATC! that is an SQL database. Our customers will receive a link to this form and when … |
| | I'm writing a program determine employee's working hours in a day by entry and exit clock in classes. In sql, I have a table, there are 4 field like : classID, cardID, date and clock. Teacher come to class and every teacher have an unique card. Card reader read this … |
 | Please, estimate the operation of [url=http://design.antigov.org]engine for site[/url] All the pages are made only in HTML, and there is only the text of central column material; building of menu and of other things, display of CSS styles are performed with Java Script, it should be put at the beginning of … |
| | I m using LAN Connection,My system used as remot , When i going to run , my system become HANG!!! i m doing VB.Net Programs , using sql2000 backend What shoud i do ??? Can u help me......?????????? |
| | hi folks.. In my application am storing some textbox values to a datatable inside a dataset.Now I want to save the multiple rows of datatable to my sqltable..ll anybody plz help me.. with thanks and regards. jithesh.P.  |
| | Hi All Thanks in advance for any advice. In the data centric application that I am currently working on, I have a requirement to create a database on the client machine. I understand the whole process of creating the database (tables, sprocs etc), but what I cant seem to figure … |
| | Hi, I want to join a table with itself to get all possible combinations of the variable Name in two columns. My first attempt was this: [CODE] SELECT P1.Name, P2.Name FROM Pairs AS P1 INNER JOIN Pairs AS P2 ON P1.Group = P2.Group WHERE P1.Name <> P2.Name [/CODE] The thing … |
 | I need help with creating a "booking system", i had already done some tables,and i need help with the coding part,especially concerning the relationships between the tables.Thankyou  |
| | So, I've been poking around in MS SQL for a while and it kinda looks like Access a little, but it seems harder to enter data, change data, etc. Not very user friendly to a person used to Access. I've been using Enterprise Manager and Query Analizer, but it takes … |
| | We are using 4 systems ..... system1 is only having SQL Server , in my system i m having setup for SQl , How can i register my system?????? i did the following things... Start >>> Programs >>> Microsoft Sql Server >>> Enterprise Maneger Then Sql Enterprise Maneger Page opened … |
| | hello to all, Im trying to load xml file to sql server but I dont have enough knowledge how to create schema xml, as of now im using vbscript program to upload my xml, here is my vbscript codings, Set objBL = CreateObject("SQLXMLBulkLoad.SQLXMLBulkLoad") objBL.ConnectionString = "provider=SQLOLEDB.1;data source=codevelopment;database=Johnny;uid=restorer;pwd=" objBL.ErrorLogFile = "c:\error.log" … |
| | I've been trying to run an SQL script using an Excel macro. There are hundreds of records (one coumn - Item numbers) returned, and I would love to have the results start at C3 in the Excel worksheet and propagate down until all of the records have been added to … |
| | Just a quick question... Where would I post a question on running an sql script from Excel and storing the results within an Excel worksheet?  |
| | |
| | Hi, I need help on this sql. I have a table a and b and i need to select where a.id=b.id and b.mid=1 and few hardcoded a.id which does't exist in table b. i used left outer join but its still listing all in a table. Can anyone help pls. … |
| | Hi Guys and Lassies, Currently creating a program and need one bit of info to complete. Using really simple code (Not SQL) I want to select a name from a dropdown combo, and once selected, displays the name in a label, AS WELL as displaying relevant info from a database … |
| | Hello to everyone! I'm developing a C# application that manages an Access database. In order to perform a word search within the database registers, I have used a SQL command based on the 'LIKE' condition. I attach the complete code below: [code] myConnection.Open(); OleDbDataAdapter adapt_pregunta = new OleDbDataAdapter(); string query_c … |
| | Hello to everyone! I'm developing a C# application that manages an Access database. In order to perform a word search within the database registers, I have used a SQL command based on the 'LIKE' condition. I attach the complete code below: [code] myConnection.Open(); OleDbDataAdapter adapt_pregunta = new OleDbDataAdapter(); string query_c … |
| | I am working with a database table that has a list projects. Some of these projects have sub-projects. There is a column with weekending dates with corespond to manhours associated with that week. Here is an example. JobNum SubJobNum WeekEndingDate Manhours -------------------------------------------------------------------------- 1 001 8-17-08 200 1 001 8-24-08 300 … |
| | I'm trying to find information on how to import selected data from one SQL database to another using C# (or any language for that matter) or the cmd line. aka: I dont want to use the wizard. I could export to a CSV file, then import... but that seems needslessly … |
| | Hi all, Does anyone have any experience with a PHP Web-based form builder/administrator that's designed to use MS SQL? I know there's a lot of PHP/MySQL-based products out there, but I have to use MS SQL. I need to be able to create Web forms relatively easily with a Web-based …  |
 | when typed in vs2005 command prompt aspnet_regsql.exe it gives error:application failed to initialize properly; |
| | |
| | Hey guys I have installed SQL Server 2005 Developers edtion and I have noticed that I dont have SQL Management Studio feature available. I am currently in the process of reinstalling just incase I missed out an option during installation. What concerns me is: Is Management Studio available on SQL … |
| | Guys Im not sure If I should post this in this forum but anyways If it shouldnt be here please pardon me I have a problem here, I have to design and develop a software for Clothing company which sells clothes, either use account, cash, credit exchange, returns and so … |
| | hii i wanted to insert questions, options and correct answer in the database(Multiple choice questions). I have around 8000 questions to be inserted. I tried with copying entire content from word into notepad and provided delimiters for questions and answers but the entire question appears in a single line(it is …  |
| | |
| | Hi. I have previously designed an ASP.NET system that interacted with SQL Server 2005. I now want to design a desktop application using Visual Studio 2008 that interacts with an SQL database. I had planned to use the same sort of coding to implement this new system. For example - …  |
| | |
| | Hi: I am writing code in VB but SQL is the major role here.. I am checking if MFG="DELL" in table1 and if that is there I need a msg box saying "DELL is supported" [QUOTE] Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click Dim con … |
 | Hi! Is there any way I can save a database as an SQL file? Or at least save schema if saving data is not possible. Thanks in adv. |
The End.