2,569 Topics
 | |
| | I'm trying to connect a SQL database to a Classic ASP site. I keep getting the following error message no matter what I do: ADODB.Connection error '800a0e7a' Provider cannot be found. It may not be properly installed. I have an ODBC entry for this database, as well as have the … |
| | I have a table similar to the one below: Month | Item | Qty | Cost of Items purchased Jun | 1 | 10 | 50 May | 1 | 5 | 0 Apr | 1 | 5 | -18 Mar | 1 | 7 | 0 Feb | 1 … |
| | I am trying to create a plant reference guide where the customer can grab plant description from one table (findplantsdb) and the availability from another table (plantsdb). I am new to PHP and I think I am close, but what is happening is that the plant description is coming up, …  |
| | I'm trying to formulate the proper SQL query to pull a roster up on this database I was asked to produce for my kids' HS band. Arrghh. Any help would be great. I have 3 tables. [CODE][U]student[/U] student_ID {PK} first_name last_name email family_ID {FK} [U]family[/U] family_ID {PK} family_phone [U]adult[/U] adult_ID … |
| | [code]<% String UN=request.getParameter("un"); String pw=request.getParameter("pw"); String FN=request.getParameter("FN"); String LN=request.getParameter("LN"); String L1=request.getParameter("L1"); String L2=request.getParameter("L2"); String L3=request.getParameter("L3"); String ccn=request.getParameter("ccn"); Class.forName("com.mysql.jdbc.Driver").newInstance(); java.sql.Connection myConn; myConn = DriverManager.getConnection ("jdbc:mysql://localhost:3306/train_resev","root", "3866" ); PreparedStatement ps=myConn.prepareStatement("insert into user values('" + un + "','" + pw + "','" + FN + "','" + LN + "','" + L1 + … |
| | I have had a look within daniweb and done google searches on this problem so hopefully I am not wasting anybodys time with this. The problem I am facing is that currently I am getting the results from a mysql database using an associative array but i need to be … |
| | Hello, i attempting to edit an online payment form to connect to MySQl, i have managed to get everyting working up until the payment page. The problem i am having is sending the cart contents via encrytion to the server. When there is one product, there are no issues. If … |
| | what query should i write in c# with backend sql server for finding all purchases i did from george in a date range. from purchases table.  |
| | hi guys! i have a problem regarding the queries i coded. my first query is to display the category name, description and maxscore: SELECT c.cat_name, g.maxscore, g.description FROM grp_performance INNER JOIN category c ON g.cat_id = c.cat_id the problem is, i don't know how to delete the row in the … |
| | please tell me c# code i want to determine largest number in a column of sql server 2000 table and store it in a variable.  |
 | Hi, I'm becoming more paranoid of security issues (Not Insane anyway :)) and would like to ask you guys what do you do to prevent SQL injection apart from using parametrized query and data validation. Thanks |
| | I always get this error: "Error updating joke: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1' at line 1" There's something about this part of my code that causes that error and …  |
| | Hello, I am currently working on a stored procedure that shows the time of day as an integer value: 456, which means 4:56. I was wondering if there is a way in SQL that I can convert this int in to a datetime value. So instead of the time appearing …  |
| | |
 | how do retrieve the last record if its id or other fields are unknown...or simply i need to move the record pointer to the last record in a table...thanx a lot... SELECT * from stud_infos WHERE stud_id = 'HOW DO I DO IT?' |
| | I have a table with entries for different accounts and each account has different products listed in it with a date next to each entry. An example of the structure is below. Account | Product | Holding | Date A1 | Car1 | 2 | 2010-12-31 A1 | Car2 | …  |
| | Hello people :) i'm trying to insert query result into 2 dimensional array i have tried the following way.. [CODE] $query=mysql_query("..."); while($row=mysql_fetch_array($query)){ for($i=0;$i<=$index;$i++){ if(isset($myarray[$i]['array1'])|| isset($myarray[$i]['array2'])){ array_unshift($myarray[$i]['array1'],$row['study_period']); array_unshift($myarray[$i]['array2'],$row['test']); }//endif }//endfor }//endwhile [/CODE] But, it failed i also tried.. [CODE] $query=mysql_query("..."); while($row=mysql_fetch_array($query)){ $myarray=array( array("array1"=>$row['study_period'],"array2"=>$row['test']) ); }//endwhile [/CODE] it failed too since it … |
| | Hello all, I'm trying to build a forum site. The code below works fine but I dont know how to catch it from the address bar. I'm having trouble finding tutorials to help me with this. viewtopics.php [CODE] echo "<tr bgcolor='#6698FF' ><td><a href='viewcomments.php?id=".$rows['topic']."'> ".$rows['topic']."</a></td><td>".$rows['username']."</td><td>".$rows['timestamp']."</td></tr>"; [/CODE] Address Bar [CODE] http://localhost/testsite/viewcomments.php?id=Cowboys%20Dancehall [/CODE] … |
| | So i have this problem with a database. Under a section Date of Birth there are about 110000 entries. There are some that just have the year, for example 1978, I'm wondering if there is a way where it can automatically put in /00/00 after the 1978? so it would … |
| | I have a PHP shopping cart system and it's using MS SQL for the backend. Currently it's using the mssql driver. Now I want to move it to Windows Azure and I'm required to change the driver to sqlsrv 2 in order for it to work there. Can anybody tell … |
 | Imagine my surprise when I logged onto Daniweb and saw a scrolling advert for IBMs Informix database. I've been using Informix for years and it is an incredibly elegant bit of code, and the object extensions you can use are totally unique. I'd always thought of Informix as a secret …  |
| | Hi all, I am having some difficulty in finding how to make a Table Valued Function (TVF) work in C# and T-SQL. I have managed to get a Scalar Valued Function (SVF) working perfectly however I have not been able to find any adequate documentation on how to implement a … |
| | a browse and submit button when pick the image and submit , the image name goes to my SQL table and the image it self that the customer pick it copied to my "upload" folder :( my problem is that i only see the image name , so my issue … |
| | Ok I am stumped. I am inserting the data fine into the table and database so i know its not the config.php nor opendb.php. I used a code like this before and it work, i've only altered the $sql, the td's, and the $rows[]. Table name is hotspots (all lower …  |
| | I have a query which generates a soccer standings table and although it works fine there I am trying to implement a couple of variations on it but everything I have tried has failed. I have searched and asked many times and for both problems and it seems as though … |
| | Hi Friends i have some problem in update my dynamic text box value for particular id alone, i want to update only the 2 column fields into my database, i have used the below code. i am not able update the fields into my DB. Please help me to solve … |
| | I am not sure I am under the write forum but here is my problem: I have a pretty simple program written that works just have a lot of repeated code and am not sure how to condense it in this situation. The program reads in table names from the … |
 | Hey guys, As you can see below I am trying to add row of data to a table called tblOut. When i execute the code, it works without a single error message but the problem is I dont see any new record when i preview my table data. Can anyone … |
| | I have uninstalled sql server 2005 but failed to uninstall SQl Server 2005 Management Studio Express. To install Sql Server 2008 Management Studio I need to uninstall Sql Server 2005 Studio otherwise I can't proceed further! Can anybody suggest an easy and clean way to uninstall SQl Server 2005 Management … |
| | Hi, I have some difficulty with my 'select' In my select/menu, I display all the options come from a table (table_db_email) in my database In this table ([B]tb_code_prmtn11_email[/B]) I have two field : [B]fld_email_id fld_name_email[/B] It works here is a code [CODE]<select name="email_adress_menu" id="email_adress_menu" class="valid" onchange="submit()"> <?php echo "<option selected=\"selected\" … |
 | Hi im new to sql server 2005 and i have a big problem. i want to delete a record having the same name and surname Here is my table named Students StudID FirstName LastName 1 Erwin Lopez 2 Archie Lopez 3 Lobanz Lopez 4 Erwin Lopez 5 Chie Lopez 6 …  |
| | I am getting this error when i try to connect to the server... Hot to rectify it... "This version of Microsoft SQL server Management Studio Express can only be used to connect to SQL Server 2000 and SQL Server 2005 servers. (Microsoft.SqlServer.Express.ConnectionDlg)  |
 | Hello Group, I'm running with MS XP Professional, version 2002, service pack 3. Many of you may well have already heard that there are some problems being encountered by some users with trying to install the update for SQL S/Pack 3. KB970892. As I do a lot of traveling with … |
| | hi all, please help me on this... Is there a way to get the SQl View's String Command used to create said View? For Example, I have a View named tryView, now I want to get the string command used to create tryView like this one... [QUOTE] CREATE VIEW tryView … |
| | - I'm using ms sql and then i export the database and then i save that export DB at desktop.After that i delete the database in ms sql because i want to learn how to import the DB.My problem is cannot import the DB that i export before.Anyone can help … |
| | Hi all, I need your help. I have an insert query which insert a few rows into the table A. TableA has two primary keys, which are fieldA and fieldB. The SQL is written as follows: INSERT INTO TableA (fieldA , fieldB, fieldC, fieldD) SELECT DISTINCTROW TableB.fieldA, TableB.fieldB, TableB.fieldC, TableB.fieldD … |
 | Hi guys. I know this is a long shot, but does anyone know if parallel computing (multiple simultaneous programmers/developers working on the same file) is possible for SQL databases? What I'm wondering if is possible is working on a local database that updates the mdf file in two computers, which … |
| | Hello :D we've been working on this simple student database where we can add, edit and delete a student record... sooo going straight to the point I'm having problem with displaying details from two different tables as you can see we can only open using one connection string and try … |
| | I have written some sql codes in a file named sql.sql and I want to install my database using this file. How can I do it? Please help me out.... here is the sql code from the file sql.sql [CODE] CREATE DATABASE IF NOT EXISTS wm; USE wm; CREATE TABLE … |
| | Hi, Although I'm not really a novice when talking about web development, I'm not really used to writing MySQL queries that are a bit more advanced than the absolute basic SELECT/INSERT/UPDATE/DELETE queries. Anyway, currently I started working on a project that shows relevant items to the user: A 'you might … |
 | Hey Guys, I have an "events" table in my DB and a "default_events" table also. Every day I display one event. I check to see if any rows in the "events" table match todays date and then display that event, if no events match by date, I check the "default_events" … |
| | Hi all, I am trying a scenario for calling a shell script when ever a trigger is called. Can some one guide me how to achive this scenario. Also it should passes the value from the table to the shell script. Can some one explain me along with the example. …  |
| | i want try to update the value of record from table1 where the value i need is from table2 like: table1 [CODE]Item_id | Quantity 0001 | 100 0002 | 200 0003 | 300[/CODE] [CODE]table2 Item_id | Quantity 0002 | 100 0003 | 50[/CODE] [CODE]when the query run.... i want the … |
| | In my application some stored procedures are not working properly in current database of SQL Server. I have taken backup of database 2 weeks ago and all stored procedures are working in backup database. I have checked the properties of current database and backup database both are same. After restoring … |
| | Hey guys.. could someone please help me with.. What wrong with this: [CODE] echo "<td width='25%'><img src='images/Lock.png' title='" . $row['username'] . "' - '" . $row['password'] . "'></td>";[/CODE] i Get only the username.. Cheers, Sagive |
 | I have made the mistake of adding a large amount of comma separated data to a specific field in a certain table without adding spaces between each! (Stupidly didn’t realise the associated application requires spaces!) Now I am trying to create a query that can add these spaces in automatically …  |
| | The code given below is showing error: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'group,type) SELECT ex_tax.username,ex_tax.exp_id,exp' at line 1 [CODE]$sql="INSERT INTO ex_cat (username,exp_id,used_category,group,type) SELECT ex_tax.username,ex_tax.exp_id,ex_tax.category,ex_tax.group,ex_tax.type FROM ex_tax WHERE ex_tax.username='$uname' AND … |
| | Hi, Does anyone know how too solve this: I want to delete a row from database and I keep getting this error: [B]The ntext and image data types cannot be used in WHERE, HAVING, GROUP BY, ON, or IN clauses, except when these data types are used with the LIKE … |
| | The case scenario is like I have to check all available usernames/names from the databases whenever I type the letters instanly. For example:- When type "je" in the userfield, it should show all combination of names starting with "je" inline. I am attaching a picture as sample. Its indian railway … |
| | hi i have a drop down list where i select an employee id, once i click the button i want it to populate the Rate text box with the rate which matches the id from the table in sql. i have this so far but not sure if i have … |
The End.