2,570 Topics
 | |
| | Hey guys, only new to Daniweb, so pardon me, if i seem too "nooby" for you guys. I am building a website, and currently am working on the "members area" i have a database named "users" with fields "name", "username", "email", and "password". i am running a php script, and …  |
 | i have one list and one database. The list is made after i've decided a number in a numbericUpDown. So for an example i can get the list fj1Section: 1 34 33 32 31 20 19 18 17 16 each of this sections exists in the database in the 2. … |
| | Hello Everyone, I'm quiet new to PHP, and I'm making a news portal practicing the language. I have an index page where the news are posted in an order-> [url]www.fundis.hu/index.php[/url] I have a results page, where is a search engine -> [url]www.fundis.hu/results.php[/url] In the index page I used dynamic links … |
| | I have installed MySql here already, now i need to connec it because I am going to make a project which it needs a Database, but my problem is that I don't know how to set the connector/j/ I don't know how to install it/I don't know how to put …  |
| | HELP!! I try to bind a textbox to a datatable but i cant.. I checked if the datatable is filled (it includes the results of a sql query)and it s ok.. i can depict the result in a combo box but not in textbox. I wait for only one result …  |
| | [CODE]select * from Table where data=2.6[/CODE] After running the above query, db returned an empty result set. But Seen from table, there are many rows matching data=2.6 criterion. Here the type of 'data' column is FLOAT. If changing the value to an integer like 'where data=2', the matched result sets … |
| | Hi guys, Im writing a windows c# form at the moment and after all the headaches of gettin my stored procedure to combine 2 tables from 2 databases from 2 servers that had different collations(.....yeh MASSIVE headache)ive hit another snag! here's my form1 code, no where near completed, missing my … |
| | Hi, well im working on a project for school but I can't seem to get it to work. Its an app that is connected to a DB with 3 tables, this is my sql syntax of the db: [CODE] Table structure for table `income` CREATE TABLE `income` ( `idincome` int(11) …  |
| | Hi all, im doing a program using java and sql, and im trying to set a textbox with a value stored in a database. thing is: i have a combo with airlines, and each airline has a cost for each seat. so what im trying to do is get this … |
| | I have a drop down menu on a page where the user can select between, All, House, Unit and Rural which send the selection to a stored procedure which access' the database and returns the information with the selection eg. House from the category column. It all works great when … |
| | Anyone help me as soon as possible : Sir/Mam I want to pass more than 1 value through Query String I use the Code but it not working : [CODE] <tr> <td><a href="patmedrcd.jsp?id=<%=patid%> & q123=<%=qid%>"> View Patient's Medical Record</a></td> <td></td> </tr> [/CODE] and i get the value by this code …  |
| | I'm new to stored procedures and, really anything about sql beyond the basic SELECT/INSERT/etc... so this is probably just something I don't understand but my problem is that my stored procedure seems to only return the last row of the result set (i.e. if it should return 10 items it … |
| | Hai , I have a table Student_transport_Details having columns : UserId DesignatonId StartDate Enddate I need to get records for a particular month. Can i retrieve records by passing MonthId [between 1 -12]. Thanks in advance |
| | Hi All I am writing an import program to import data from an access database to a SQL database. The table structure in the SQL and Access are the exact same with the same field names. I was wondering if there was a quick way to get the data into … |
 | I have a sql query with that adds numerical values from different table to find total for a shipment. When I execute this query, it works fine for the first record but rest of the records show null value when I know there are records present. SQL pros please take … |
| | I've developed a software using VB.net and SQL server 2005. This is the connection string that used. [CODE]Data Source=MY-PC\SQLEXPRESS;Initial Catalog=studentInformation; Integrated Security=True[/CODE] But now i want to use SQL server compact edition. So what should i change in this connection string? |
| | I couldnt find a forum for sql so Im going to post here. If Im in the wrong forum then please move me. I have a table with following data Fields: OID, Product, Condition, QTY DATA: 1, Product A, NEW, 60 2, Product A, B, 60 3, Product A, C, … |
| | Hello All, I have two tables that can't be changed. One contains Stock codes / country codes, the other has country code / description for each code. I have a combobox with all the country descriptions that can be added to the stock code table. my problems is i can't … |
| | Hi guys, I'm wondering if there is a way to solve this problem. Currently, I have an SQL statement that goes this way: [CODE]SELECT distinct name,id from list [/CODE] My understanding is that it selects the things that are distinct on both tables. Example: id name 1 Joe 2 Joe … |
| | Heya people, Here's my problem: i have a (for me quite lengthy) piece of SQL code which is automagically generated by my own application. However, when i try to execute it, it gives me an recordSet error ("Either BOF of EOF is true, or the current record has been deleted"). … |
| | Hai , I have 2 tables 1. [B]Transport_Details[/B] having columns user_id FareStageId StartDate EndDate and 2. [B]Route_Fee[/B] having columns FareStageId monthId fees I need to get a monthwise list by passing monthid. My problem is that , if start date and enddate of a user are 02-08-2011 and 20-02-2012 and … |
 | I have tried this : [CODE]update customers set customers.acc_balance = (select sum (invoices.inv_amount) from customers left join invoices on customers.cust_id=invoices.cust_id group by customers.cust_id)[/CODE] this [CODE]update customers set customers.acc_balance = (select sum (invoices.inv_amount) from customers inner join invoices on customers.cust_id=invoices.cust_id group by customers.cust_id)[/CODE] error is : Subquery returned more than 1 … |
| | help me update my database.. when i click edit it will add a new record.. i want to update a record.. to edit a new record it will be base on the cutsomer's nameu [CODE]Dim conn As ADODB.Connection Dim RS As New ADODB.Recordset Set conn = New ADODB.Connection conn.ConnectionString = … |
| | Ok I am stumped so bad. I am using a form to insert a topic and comment into a table and if the topic is new it creates a new table specific to that topic. So I pass the topic name through the url and Im trying to retrieve it …  |
| | I have run into an interesting problem. I have inherited a database for daemon process that polls and accepts reports from remote embedded systems. Each site that has one of these systems can monitor over a dozen different fuel tanks. (In practice, most monitor 2, 3 or 4 tanks.) When …  |
 | Hello everyone, I'm a java programmer writing a half graphical half text rpg. For the moment I read my data from text files, e.g. Enemies.txt id name hp and so forth. However, I want to make it a little more clear to handle, as in a database format. I can … |
| | Hi all, I've a very weird problem. Actually I've Sql setups as .iso and from those setups i need to extract binary version of "sqlsrv.exe", but it is not possible for me to install every single version of sql and install and then generate binary version so does any one … |
 | Hey guys, I am making a bot for a link sharing site. I am using the request external curl class and i have a dilemma that i think you guys could help with. Query Variables appended on the end of a url such as ?something=234 I do not know how … |
| | I want to use jQuery tooltip in a table which is created with php doing a while loop. I want that when i hover over a row, the tooltip fills up with data according to that row. I found something similar using asp.net, but i dont know how to implement … |
 | I have a theory about the design of a new site I am working on. If a user accounts table is in one database, and the site content tables in another database, then it would be impossible for a hacker to use SQL injections in a form unrelated to the … |
The End.