6,934 Topics
 | |
| | View the full tutorial at [URL="http://www.effectivewebdesign.co.nz/tutorial.php"]http://www.effectivewebdesign.co.nz/tutorial.php[/URL] I have tested this many times and it works fine. Please don't complain unless you really can't get it working, Just PM me and I'll fill in the blanks Happy Coding :) |
| | 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 … |
| | |
| | hey guys!!! I tried downloading oracle 10g release2& 11g release2 and both of them failed during the universal download. On both links it told me it should be 5.1 or 5.2, actual 6.0? Can anyone please help me here. I tried doing this 2 times and the same result. I …  |
| | 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 … |
| | Can You Please help me where I am getting error.. :( I am using NetBeans and MicroSoft SQL Server 2005. [B]HTML CODE[/B] [CODE]<html> <head> <title></title> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> </head> <body> <form action="movie.jsp" method="POST"> <p><strong> List Of Movies:-</strong>s</p> <select name="moviename"> <option>powe</option> <option>ghi</option> <option>xyz</option> <option>Troy</option> <option>poer</option> <option>abc</option> <option>pqr</option> <option>qwe</option> <option>ghj</option> <option>RA … |
| | 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.  |
 | I know this makes no sense at all, but hear me out and maybe someone can supply me with some info on how this can be accomplished correctly. Using an invoicing type example. You have a table of clients who can receive invoices, a table of invoices with invoice numbers … |
| | 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 … |
| | could you help me, please ! ... because i am newbie, sorry :) at form vb net 2005, i can browse file .mdb (C:\my documents\db1.mdb), I have created a table in sql server database, where table is the same as the access table that will be imported, after that when … |
| | I have a piece of code that takes two strings, puts them together, then attempts to save that result into a table in a database. For some reason, the database is only showing the second half of the string ([ICODE]Me.txtRev.text[/ICODE] in this case). When in debug, I can see that …  |
 | Hi everyone I've been having a small problem. on learning process of vb.net and sql server 2005 I hit a wall I want to know how can I filter the items on my datagrid which is displaying the data from my SQL server database, through a textebox text. sorry 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.  |
| | WHY WHEN I EXECUTE THE BELOW CODE I GETS AN EXCEPTION [B]java.sql.SQLException: No ResultSet was produced[/B].........BUT EVEN THOUGH INSERTION OPERATION WORKS FINE........CAN ANYONE TELL ME WHY THIS EXCEPTION COMES [CODE=java] Connection co; try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); co = DriverManager.getConnection("jdbc:odbc:hh"); Statement st1; ResultSet result; st1 = co.createStatement(); result=st1.executeQuery("select count(*) from rooms"); result.next(); … |
 | 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 …  |
 | Here is the image of the table of the Question [url]http://oi55.tinypic.com/2d0gkmh.jpg[/url] Here is the First question(in the image) [url]http://oi52.tinypic.com/2ztix5l.jpg[/url] Above one is question (c) help me to answer that this is the other question(below, as Text) d) Create a database view to display the above output of part (c). help … |
| | 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 …  |
| | Hello: I'm trying to select specific data from code 2 below, using the variable $clientID queried from code 1 (also below). The question is if code 1 iterates a series of rows containing variables $clientID (say about 10 unique $clientID's); how can I write code 2 to go through each … |
| | I have the following code which performs a sql select with a where condition involving an array. I want subsequent queries (within the same code) to be performed using each unique value of the array Here are the specifics: This initial query begins the process by creating an array from … |
| | Please i need to know how to schedule an auto backup for my program database. Please anyone with ideas? |
| | |
| | Hi Guys need your help on this :( Basically I am developing a web crawler so once the html source is converted to plaintext in a textbox, i intent to save it in dB. But the dB seems to be having trouble excepting some characters into the table and throwing … |
| | hello all i kindly help me out i have a table in sql server with transaction id and amount i want to add the amount values of those rows where id is same for example i have 4 times 2 in transaction id table now i want to add all … |
 | 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?' |
| | hi, this is satish,I have faced problem to update the gridview with template columns without using sql datasource.So please send me the code with events for updating gridview with teplate columns including one dropdownlist inatead of textbox without using sql data source. i hope you will understand my question, please … |
 | I m trying to connect an sql express database over lan. my connection string is as below. Data Source=Mr-4f04a26307ff\sqlexpress; AttachDBFilename=F:\\Projects\\MyProj\\FirstProj\\bin\\Debug\\Database\\MyDB.mdf;Integrated Security=ture; User Instance=true; but unable to connect and throw this exception Login Failed for user 'Mr-4f04a26307ff\Guest' What is the problem with this and what is the solution. thnx |
| | Hi Folks, I have a simple app (coded in VB 2008 Express Edition) that uses an SQL Server database (in .mdf format) that works fine on my own machine. I created the database in SQL Server on this machine. I added the DB as a data source and it works … |
| | Hi, I have 2 spreadsheets with say the following data: Spreadsheet 1: Column 1 Column 2 Eatables A Eatables B Apple Watermelom Orange Apple Banana Peach Apple Spreadsheet 2: Column 1 Column 2 Eatables Status Apple Eat Orange Don't Eat Banana Eat Peach Eat Watermelon Eat Tomatoes Don't Eat Avocado … |
| | how to populate treeview from multiple columns of sql data table I have attached my sql table here.from that table,i have to populate a treeview of the below form; -outlook ---------overcast -----------------------------yes ---------rainy ----------------wind ----------------------strong ------------------------------no ----------------------weak -------------------------------yes ---------sunny ---------------humidity ------------------------high --------------------------------no -------------------------normal ---------------------------------yes. It is readable like this; if … |
| | The below line generates this error. Can anyone gives me a solution Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in C:\wamp\www\MySite\php files\approve_page.php on line 25 [CODE] $query = "UPDATE transaction SET approved_status='1' WHERE account_number='$account_number' AND tran_id='$_POST['tran_id']'"; [/CODE] |
| | hi.. i m making a university project on a dental clinic i have two tables one containing information abt the visits in a dental clinic(tbl_daily_opd) and the other containing the details of the patient(tbl_patient).. tbl_daily_opd contains only the id of the patient.. i m printing tbl_daily_opd in the report with … |
| | 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 all, I've a seemingly simple question, but it's kind of got me thinkin there might be a "proper" way to accomplish my goal. My goal is a simple MySQL database schema install. In PHPMyAdmin I export a database, any database. I then save the file to the root directory … |
| | i have a project connected with sql server 2000... i want to generate the some reports, for that user should itself enter the dates or codes for reports.. i have created a data environment, called the tables. now in general tab, i have selected SQL Statement to filter my data …  |
| | CREATE TABLE `employee`(`employee_no` CHAR(4) NOT NULL,`emp_name` TEXT,`employee_sal` INT NOT NULL,primary key (employee_no); << I typed this and it says there is an error (see below).I can't see what is it.000webhost.com Mysql server [CODE]Error SQL query: CREATE TABLE `employee` ( `employee_no` CHAR( 4 ) NOT NULL , `emp_name` TEXT, `employee_sal` INT … |
| | Hi! my code gives me this error. "An object reference is required for the non-static field, method, or property 'HD.RegisterMember.CN'" Plz can anyone help me. This is my code(Class); [CODE] private SqlConnection CN; public static String getLastMemID() { String ID = null; try { CN = new SqlConnection("Data Source=BJ-PC\\SQLEXPRESS;Initial Catalog=DB;Integrated … |
| | hi, i have a table stu_record and a field name is image_student as a image type and image save in it in binary form. nor when i'm login i want to store this image into a session variable. and on other pages this session value store into another table as … |
 | I installed Oracle 11g R2 on my Windows 7 64-bit OS.When i'm trying to login to SQL Plus,i can't.As i remember my Username and password is correct.Is there any method to login without giving username and password? or is there a way to get my username & password?Please help me.... |
| | i'm not too familiar with java...though... actually i'm trying to insert the values entered by the user into the access table but every time i click the add button on my application it shows [I]java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. [/I] error... [CODE]String str="insert into … |
 | Hello Everyone For a project from skool, I been in charge of development, and we already have the system, but they wanted to add images to the project, and since i been using the TableAdapter.Insert commando to add records to the database, I need to know how to send an … |
| | Hello All Developeres, Please Read Below Senario. I have one table Supposed "Emp(EmpID,EmpName)" Now There is data with Name "testName1" and "testName2" in EmpName Field Now I need query which fetch all record in asceding order for EmpName Field and Record with "testName1" and "testName2" will must display at [B]last[/B]. … |
| | [code]StrSQLQ1 = "SELECT " & _ "CustomerCharges.JobOrderID, CustomerCharges.ClientID, CustomerCharges.ActivityDate, CustomerCharges.TaskName, CustomerCharges.Charges, CustomerCharges.LineSeqID, CustomerCharges.IIDNo,CustomerCharges.consignee CustomerCharges.marking, CustomerCharges.rate, CustomerCharges.m3, CustomerCharges.tonn,CustomerCharges.labor, CustomerCharges.storg, CustomerCharges.overtm, " & _ "JobOrderHeader.JobType, JobOrderHeader.CustomerName, JobOrderHeader.LedgerNo, " & _ "JobOrderLine.LorryOutDt, JobOrderLine.FL, JobOrderLine.VesselIn, JobOrderLine.ContainerTruckNo, JobOrderLine.ContainerSz " & _ "From " & _ " { oj (WMS.dbo.JobOrderLine JobOrderLine INNER JOIN WMS.dbo.CustomerCharges CustomerCharges ON …  |
| | Hi All, If someone can help me with this I would be eternally grateful here. I have created a form on one page with php validation. Once cleared through the validation I have Sessioned the inputted data to catch them on the "insert data page" on the "insert data page" … |
The End.