2,569 Topics
 | |
| | 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 … |
| | So I have a database that stores when someone leaves and when they return to. dayleft dayreturned I need to do a query and also an cfif to see if a date selected is between these dates. test - selected date the Here is my long if [CODE] <cfif (datecompare(vactrue.dayreturned, … |
| | I would be grateful if someone could suggest what I need to do to get this to work. I have copied two short scripts which should demo the use of $_session, but the read script does not work. I believe the save script is the culprit though. Here they are: … |
| | 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 guys, I have a problem on getting the selected radio button and save it in the database. Here is my code: [CODE] <div id="container"> <div id="question1" style="display: inline;"> <p>Question 1</p> <ul> <li><input type="radio" name="q1" value="1" id="ans1" />Answer 1</li> <li><input type="radio" name="q2" value="2" id="ans1"/>Answer 2</li> <li><input type="radio" name="q3" value="3" id="ans1"/>Answer …  |
| | 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 …  |
| | I want to learn basic web query vc++.I googled around and found that libcurl was the library needed.I have downloaded the necessary files from curl.haxx.se .I do not know how to use these files and make the actual header file and then actually include it in my project. Any help …  |
| | 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] … |
| | I am developing a project for a client with a single table in the database for users which includes information about each user, including a field for the userID of a user who referred them. What I need to do is query the "referrer" field of each user record and … |
| | 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 there, I need some help with a query .. Table gamedate cutofftime 2011-08-25 13:55 I want to list games that are today +7 days but today games where the cutoff time has passed should not be displayed. Can anyone help me with this query please. Thank you for any … |
| | 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 am using SQL Server 2005. I have a data from SQL like this. ID ID2 PartNo 75 23921 DENT 75 26145 PLGD 75 26145 PRRP 75 26145 SIST 75 57290 PRMD 75 57290 abc 75 57290 def 75 57290 ghi 75 57290 jkl I need an output like this. … |
| | 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 … |
| | I have a table in which I want to retrieve the table as follow. Login Name Parent User Email ID Mobile No abc abc_parent [email]abc@abc.com[/email] 9999999999 MySql Table as follow in tbl_users user_id parent_user loginname email mobile 321 123 abc_parent [email]abc@abc.com[/email] 9999999999 231 456 abc [email]123@123.com[/email] 8888888888 I am having … |
| | 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 … |
 | Can someone please tell me what i am doing wrong with this code. I have created a dataset and want to push that data into crystal reports. [CODE] Dim rpt As New CrystalReport1() 'The report you created. Dim myConnection As SqlConnection Dim MyCommand As New SqlCommand() Dim myDA As New …  |
| | 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 … |
| | I have a Database that stores a residentID, apartment, MoveInDate, and MoveOutDate. I am trying to run a query from this database to find the resident row where the MoveOutDate is NULL so I can enter the date they moved out. My Coldfusion is not the best and here is … |
| | 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 … |
| | I'm a NEWBIE and I have been stuck on this for days. I have one table that has the following rows: rid = Referral ID category = Category subcategory = Subcategory rbusiness = Referred Business Name rcontact = Referred Contact Name etc.. I have created the form (referral_input.php) that allows … |
| | 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 …  |
| | Hey everyone, kinda new to all this...really need some help: Ok so I want to creat a log in and registration form in VB connecting to a sql database. Databse Name: Users Table Name: UserDetails Table Fields: ID, Username, Password The ID field was specifed as primary and self incrementing … |
| | |
| | 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 … |
| | Hi, As the title states, I have a query that I use to concatenate all the rows into a single string and I use the XMLTransform method to accomplish that but I still need to add a new line separator within the XML string and so far I didn't find … |
| | I am working on an ERP based project which was created using asp.net(3.0)c# as the front end and sql server(2005) as the back end. We have completed the project but after installation on the client location, when Multiple users Login and use the same form to perform a transaction, then … |
 | Hi there, since recently i have been trying to master HTML, and now i am full ready to take on PHP therefore, just like HTML instead of making many .html files | i want to use the PHP dynamic page function that can show me pages from database. usually as … |
| | Hey guys, I am writing a web application in asp.net using c sharp. I have a web page that lets the user create a program. In this system a program is made up of many applications and an Application can belong to many programs hence a many to many relationship. … |
| | this is the code to email confirm. The user clicks on the link in the email, passing the code through url to this page. Then the data is transferred from a tmp table to main one. I have queried in phpmyadmin and it works fine. But when i actually use … |
| | Hi everyone here, Can someone please guide me in transforming XML-to-SQL output with Python? I need to create 2 tables (Books and Patrons) into SQL. How much i suppose to start with??? <?xml version="1.0" ?> <Books> <Item> <BookID>A001</BookID> <Title>A Tale of Two Cities</Title> <Author>Charles Dickens</Author> <Language>English</Language> <Year>1859</Year> <Quantity>5</Quantity> </Item> <Item> … |
| | I'm trying to set up a simple little rating system for videos on a website. If you push + it adds 1 and if you push - it subtracts 1. I've got it working just fine. However, the way i'm checking to see if you've rated it already is by …  |
| | Ok i'm trying to build a forum with jquery ajax characteristics. Below is the html/jquery coding. And i know jquery is loaded because I did the [ICODE]alert(1);[/ICODE] inside the document ready and it worked. [CODE] <!doctype> <html> <head> <title>Shouts!</title> <script src="jquery.js"></script> <script> $(document).ready(function() { $("#messages").load(function('loadchat.php'); $("#post").submit(function(){ return false; }); }); … |
| | I am building a website that hosts and streams videos. I am currently testing the site on my own server. I would like to host it remotely once it is going live. I am looking for a good and reliable hosting service that provides necessary resources for online video. The … |
| | Hello, I have developed a site in VB.Net and ASP.Net with a database backend that allows a user to enter a centre code and in return it retrieves all records from the datbase where the centre code matches the one provide in the text box. My list is appearing as … |
| | Can you all tell me the difference in these 2 codes? I'm trying to learn JQuery and ive seen this code below in the tutorials. [CODE] $DB->Query("Select * FROM time"); [/CODE] I'm use to coding queries like this. [CODE] $res = mysql_query("SELECT timestamp, name FROM time ORDER BY timestamp DESC"); … |
| | Hello everyone! I have a problem trying to get a user to be able to query the database with only the fields and specifics they want. Basically... User logs in, browses through record entries and then wants to see how many of the entries are under the age of 21 … |
| | Okay so I've searched just about everywhere but can't seem to find what I'm looking for. I'm learning as I go with PHP and I'm having a problem figuring out what is wrong. I've got two different queries calling a group of information. Within each query is a field that … |
| | I built a quick date time test page. The coding is below followed by its results. I'm entering the raw timestamp into table time because i want to be able to manipulate it once i show it (say if i want to show time and date using the same timestamp). … |
| | 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 :) |
The End.