[sql] Forum Topics

I would like to have my users type in a term and display results from two different tables. I tried using union but i'm getting errors can you help please? <?php mysql_connect ("localhost", "","") or die (mysql_error()); mysql_select_db (""); if(isset($_POST['submit']) && !empty($_POST['submit'])){ $result = ""; //USED LATER /*$term = $_POST['term']; …

Hi, i am new in asp.net and i found it quiet difficult... i was programming in classic asp and sql server, but asp.net looks quiet different, specially if i do program in C# .... Than i hase a couple of questions : 1) if i do a form with 2 …

Hi there, Once i am on my second page where i have open the record from the database with my id record, how can i populate my textboxes with the values of my record? And ho can i populate a select with another table containig the type of user by …

Hi there, i am new with asp.net and i would like to start with it!!! I was wondering if anyone could suggest me any good and easy to understand tutorial where i can learn how to make a list from sql and edit the record in a new page (add, …

Hello. I've created 2 pages that i'm currently working on. One is called; Test.php -- which just includes a basic form in HTML. <Form name ="form1" Method ="POST" Action ="result.php"> Building Name: <INPUT TYPE = "TEXT" Name ="buildingName"> Room Number: <INPUT TYPE = "TEXT" Name ="roomId"> <INPUT TYPE = "Submit" …

I am getting following error when trying to click the next or previous button on following site: http://bdworld.co/newest.php?categoryId=35 > Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/content/69/9332569/html/imagewar/newest.php on line 30 Newest Pictures! ( Others ) SQL query failed. Check your query. Error Returned: You have an …

Hi Guys, Completely new to PHP! Just wanted to play around with Fields and submit stuff to a database on localhost through xampp. This code writes to the database no problem, except no insert is happening with 'Telephone' and it throws this error; Notice: Undefined index: Telephone in C:\xampp\htdocs\Inputs\update.php on …

sample asp.net with c# sql database connection

Dear All I am using Vb.net to update a database running on SQL Server. I am using the following to increase the value of the NextPlan in the SystemControl table in a SQL database. Command.CommandText = "UPDATE SystemControl SET NextPlan = NextPlan + 1" Command.ExecuteNonQuery() Once the Command is executed …

an asp page of mine with server.ScriptTimeout=540 seconds this page is then executing a select query from a huge database table which is properly indexed BUT few times there is a SQL timeout because of conditions passed in query is there a way to handle the SQL timeout and display …

Hi i m just learning rails and i want to import my sql data to rails .. i have created database and i had run rake to create shema etc... i m using windows 7 thx

Hi All, I have a Jtable with six columns. I am displaying the contents of my database into my Jtable. Its working fine. But I am facing trouble updating the changes done in Jtable cells to appropriate database cell. In the below code when I tried to edit the First …

Hey All, I think I messed up.. I went to PhpMyAdmin and clicked export and exported all my databases with the default options to a sql file. And I downloaded a bzip file with my sql file in it. If I open the sql file it looks like BZh41AY&SYò)É<91>^@B"_<80>P^Pz÷ÿúÿÿÿðÿÿßð`4^^òPÇ»w^Fç-îä»o11ãwÞ|ú^AÜ^Aëo¨ú½Ðî^Nï:.Ó§;Såñݱèó¦ô<9b>ÓÎÞe·<92>ó»7×Ú;<98>£§Nɤ)lÓFP<94>^Tå<8b>Û^T'<86>ǭܦî°:n±@÷Þ=öõôût[Àûî÷¼>D<94>}5D7¸ÏyÕ^]zâªR<90><<9c>$P@Ð^H^B50§<94>{Th&Ò<£F<9a>^L^SLF^F<99>^@¢<9a>(hh^Y^@^F<9a>^@^@Ð^@^@^BA$^R<9e><89>詵=ªm4<99>4^Y^@^OPô<9a>h^Z^@^@^Rz©(ÔÊz£ÔñA£&<8d>© ^M^@È^M^@^@^@^H<92>^P #!4ÒzL<9a><9b>Q<99>SÄ<8d>1<88><9b>@<9e><8d>C@ …

Hi, i want to create a query which select three columns from a table on certain condition now i have got certain with three columns and i can bind this data to a datagridview but before this i want to add a column to dgv say col_new and fill its …

I need to get the value of the primarykey for the most reciently created entry in an h2 database only problem is i cant figure out how to call scope_identity() which is supposed to return a resultSet with the most reciently created key. Here is the function i am using: …

Hi All, I am having a tablespace named Incident which has eight columns . The first column is index which i kept as auto increment. The columns are 1.index(auto_increment) 2.ticket_no (String) 3.date(String) 4.description (String) 5.priority (int) 6.state (String) 7.follow_up (String) 8.status (String) Now i tried to insert test row in …

Hi, I have a table in which there are two columns. One column is id and the other is value. When I try to retrieve the data that is not empty it gives me unwanted error. I have to apply join to some tables as well. My query is something …

Several people have asked about storing binary data in a database. I coded up an example today that uses an ADODB.Stream to copy the binary data but after some fiddling I found a more direct way. If you are using MS SQL Server, the easiest way I have found is …

Hi Everyone, Been a few years since I had to post anything here so I'm glad to be back. I've been asked to do a report to show vouchers that have been issued and presented for July (this year and last year). I have done this SQL: SELECT tblOutlet.OL_NAME, Format([VI_TRANSACTION_DATE_TIME],"mmmm …

The query is return an empty value on the frist row which means that the supposed value in the first row is in the second row , etc etc . How do i correct this? $query1 = "SELECT * FROM opentrades"; //You don't need a ; like you do in …

Okay i have 2 variable named bid price and offer price . I need to fill in the values into the variables through cases. For each row of data ,i want to retrieve the rates for the currency pairs (eg. eur/usd,audusd) . I have 2 values for each currency for …

I am a college student developing a local chat application using VB.Net and SQL 2005. I have multiple clients connected to a server via local ip. My first problem is, how will I know which users are online. Each user has their own username and password in order for them …

Hey Guys, What i want it to do : 1. Combobox is displayed with a list of countys ie Limerick Dublin Cork 2. Choose County brings up second Combobox with countys towns and villages. 3. Hit search brings up relevant towns and vilages from the county chosen. What it does: …

Hello, I have two tables one for the company staff and one for their projects(table name objecte). The table objekte has 4 colums that are connected with the id of the staff. The problem is that I want a query that shows all staff's names. I have also included the …

good day can anyone help me with my sort by? nothing happens when clicking the sort no errors tried the codes 4 years ago don't know if it's still usable the sql.= i think don't work or my other query just disables it. here's my sql command thanks :D. help …

hi,i am a web developer and i have recently designed a new website [fitnizz.com](http://fitnizz.com). Now i am facing some problem related to database ,i have recentky added a new application of diet plan ,you have to just enter your weight and height in the text box and click ok,then it …

I have a page to add products. On this page is a 'categorey' dropdown and a 'subcategory' dropdown. The subcategory dropdown should fill with the options based on the category dropdown selection. The code I have so far does not fill the subcat dropdown, can anyone see a problem? code …

One of the people where I work did a migration from Access to SQL Server and just about everything migrated okay. However, all of the UPDATE and DELETE queries, when they were migrated, ended up having the "`" character interspersed throughout the query, which causes errors when trying to run …

how to create xml file from a database table using vb.net I tried a code but it doesn't retrive values from the database table How to resolve this And my code is: <%@ Page Language="VB" ContentType="text/html" ResponseEncoding="iso-8859-1" Debug="true" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> …