1,694 Topics
|
|
Hi all, pretty new to sql. have made code already for showing, adding and deleting data from database but can't seem to make the update work. any help is much appreciated. here's what I have: [CODE]<html><body><form action="update.php" method="post"> <label>Person ID:<br></label> <input type="text" name="personID" size="40" value="" maxlength="150" /> <label>Customer Name:<br></label> <input … |
|
Hello, I've always liked coding and lately I've learned a little but more of it. Now I also understand sql and db a little more. My problem is that my register.php file seems to give me a notice. Notice: Undefined index: op in C:\wamp\www\hacks4all.wapzan.com\registration\register.php on line 11 and Notice: Undefined … |
|
Hello, I am currenrtly trying to write a query in Microsoft Access 2010. This query retreives a list of values from a table I have called tblTable Some of the values are numeric and some are alpha numeric. I am trying to do the query so that when it comes … |
|
Pls help me with this... [CODE] //FINANCE.PHP <form id="frmpay" name="frmpay" method="POST" action="finance_payment.php"> <input type="radio" name="seltour[]" value="<?php echo $tour_code; ?>"> <input type="submit" value="input" name="submit" /> </form> [/CODE] once submitted.. [CODE] //FINANCE_PAYMENT.PHP if(isset($_POST['submit'])) { for($i=0;$i<$numrow;$i++){ $code = [B]$_POST['seltour'][/B][$i]; $query = "SELECT tour_amount, tour_name FROM `tbl_tour_profile` WHERE tour_code = '[B]$code[/B]'"; $result = mysql_query($query); … |
|
hey how to answer to these questions Table: Sales(CustomerID , RepID , Area , SaleDate , ProductNo , Quantity , UnitPrice , ItemTotalPrice) a)considering the above table write a function to calculate the IemTotalPrice as ItemTotalPrice=Quantity*UnitPrice b)Write a SQL statement to create the above table (you must use the above … |
|
One slippy mistake that can occur with searching Text and Numeric field is that you have to carefully add the ( ' ) character enclosing the text searching string. For example : Text search: [CODE=sql]SELECT * FROM users_log WHERE user_name='Phillip'[/CODE] Numeric search: [CODE=sql]SELECT * FROM users_log WHERE user_age=>16[/CODE] In case … |
|
I was developing a 'Payment Tracker' web application. I used MS Access as back-end database. I made a 'Payment_entry' table with user_ID and Payment_amount fields with 'Text' and 'Long integer' datatypes. Now , when I wanted to find the total payment of each user I used the following SQL command … |
|
Right now the company I work for is using Microsoft enterprise library very extensively. From what I've found online recently, these database objects aren't intended for web (asp) usage, and are relatively bloated. I don't know how accurate my research is, but I do know we have optimization problems in … |
|
Im checked my sql, its working fine. But im still getting this error: [COLOR="Red"]Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in..[/COLOR] [CODE] $sql = "SELECT date FROM tbl_tour_profile"; $result = mysql_query($sql); confirm_query($result); // this is the die function of sql $i=0; while($date_set = mysql_fetch_array($result)) { }[/CODE] |
|
hi, please help in my project in visual studio 2008 and connecting it to mySQL, I'm going to create a simple identification system, can you please help me with the codes? (Form1 - Log-in, Log-out) Here's my project proposal, I need to identify an ID number and a password. Like … |
|
Well i am using asp and VB.Net to make it to where people can check in and check out. I have gridview which has where it shows the data from my sql server that i put dummy data in. When i load my website the data shows up. I do … |
|
hello, i wrote some commands in notepad and saved it as .sql and i m running these commad at my sql by command- [COLOR="Red"]mysql>source C:\Program Files\MySQL\MySQL Server 5.0\bin\script.sql;[/COLOR] then its run.. but hat to do if i write it without giving whole path. i ren this command-- [COLOR="Red"]mysql> \. filename[/COLOR] … |
|
Hi! I'm trying to send data from a mobile application written in Java ME, to an ASP.NET website connected to an SQL server. I tried to open an httpconnection output stream in the Java ME application, and send the data in a POST to the website. The problem is I … |
|
Hello, May be the there is a very simple solution for my problem, but I am stuck on this for 2 days already. May be I had been looking at the wrong places...I would really appreciate any kinds of helps....feeling really frustrated right now. You see, for my project at … |
|
hi, i have a question in data tables. i am coding in C#. my scenario is employees have many benefits in a company such as life, health, dental, 401k and such... i have a tabel in MSSQL database to represent the employee data and a emp benefit table to hold … |
|
Hello, May be the there is a very simple solution for my problem, but I am stuck on this for 2 days already. May be I had been looking at the wrong places...I would really appreciate any kinds of helps....feeling really frustrated right now. You see, for my project at … |
|
I'm trying to make a Menu manager in PHP + SQL. My goal is to save every menu item and where it should link to in a seperate row. Every row has an internal identifier column called 'menu_id'. I also want to add a function to be able to add … |
|
Hi there, I hope someone can tell me what I'm doing wrong here. I have a SelectCommand in my asp.net page (v4) that pulls a variable from the Profile to run a subquery to get the value to test within the main query. (Confused yet?) This works for 2 of … |
|
I have a Windows Form where 225 buttons are added at the run time, also I have the database which have two columns (first column is the SeatNumber with the datatype nchar(4) and the other column is IsBooked with the datatype bit). The SeatNumber contains data like this, A1,A2,A3,A4................O13,O14,O15, The … |
|
Hello all, I have a DataGridView that is being populated via SQL with one table and is being filtered by Stock Code. I need to sort the view of one Stock Code by Nutrient names, but the sequence number is in anther SQL table. it would be easy if i … |
|
pls help me fix the error. What and where is the problem? Thanks for the help! Here is the error message >> [B] 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 ' )' … |
|
Hi We have two identical web servers in a farm and I need them to be able to share Session variables as I do not know which machine the user will be using at any given time i.e. if a user where to log in to a site on server1 … |
|
Hi, My problem is that I'm recovering data (which depend on what the user selected on a first page) from a SQL database for several language checked (also on that 1st page). I would like to create files for each one of the language selected. For now, I tried to … |
|
Well i am using asp and VB.Net to make it to where people can check in and check out. I have gridview which has where it shows the data from my sql server that i put dummy data in. When i load my website the data shows up. I do … |
|
hi there, i have a question with the address text box. i am coding in C#. at first user enters the counrty. and then he enters the zip code. the state should pop up. for eg: if 60333 comes the relevant state should come up in the textbox called state … |
|
Hi All, I have a problem I have a MySQL Table, one of the columns' Data Type is TinyInt(1) When I use this line of code it gives an error int newNumber = int.Parse(string.Format("{0}", reader["someField"])); I think the reader is reading a bool value however MySQL Table has row values … |
|
I'm creating a search function for my program, and need some help with SQL. Until now I have been using simple SQL query like [CODE] "SELECT post1 FROW table1 WHERE a=b" [/CODE] and put it into arrays. Then using that info to do another query, put it into arrays, and … |
|
I have this servlet code for retrieving contents from database and displaying it on the browser.But when I am running this code it is giving "ClassNotFound Exception" at Class.forname().I have built the path with db2jcc.jar and db2jcc_license.jar file but still this exception is thrown.Please help me [CODE] import java.io.IOException; import … |
The End.