2,570 Topics
 | |
| | 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). … |
The End.