6,934 Topics
 | |
| | HI! I'm trying to make a form where a dropdown menu is populated from mysql. My code: [CODE=php]<? $link = mysql_connect('localhost', '****', '****'); if (!$link) { die('Could not connect: ' . mysql_error()); } mysql_select_db('****'); mysql_set_charset("utf8"); $query="SELECT distinct first_name FROM names_table"; $result=mysql_query($query); ?> <select name="first_name" onChange=""> <option>Choose!</option> <? while($row=mysql_fetch_array($result)) { ?> … |
 | I've searched & searched and haven't figured it out, any help is great! I need to display certain fields from my table, right now it only displays the first row of the table. I need to display all rows in the table. Code I have right now [CODE]$query = "SELECT …  |
 | i am trying to write a SP that will return a value in vb.net here is my SP CREATE PROCEDURE ClaimTotal @Ctotal BIGINT output AS select SUM(total) from claim where @ctotal = total I want to SUM my total coloum from my table claim, and store this in a varible …  |
| | hi can anyone send the link r sample project with asp.net and calling sql server stored procedure i am new for SQL thanks regards suresh.S |
| | Hey guys, I am trying to update the Quantity field in my database on button click. I have a checkout system, and on the final checkout page it displays my basket items in a listview bulleted list. Now say there is 1 item, and the quantity is 5, upon the … |
| | Hi, I'm quite new with Data Adapter on VB.NET. I'm having a problem with retrieving data on different tables. Example database: [QUOTE][B]BookInfo[/B][INDENT]BookID: HSD993Z Title: Introduction to SQL[/INDENT] [INDENT]BookID: LDJA293 Title: Advance Computer Programming[/INDENT] [INDENT]BookID: KSKL194 Title: Object Oriented Programming[/INDENT] [B]StudentInfo[/B] [INDENT]StudentID: 2938485 FullName: Michael Zip[/INDENT] [INDENT]StudentID: 2949284 FullName: Ray Williams[/INDENT] … |
| | IIf(Time()>=TimeValue("00:00:00");IIf(Time()<=TimeValue("07:00:00");Format(Now()-1;"dd mm yyyy");Format(Now();"dd mm yyyy"))) |
| | Can anyone help with this i am trying to populate a combobox with the returned values of an SQL statement from an access database the statement returns the values that i want but don't know how to pass the values into the combobox. SQL statement SELECT DISTINCT Stock_Name FROM Stock … |
 | I wasn't sure which section to post this under but I am working on an assignment in SQL and have created a batch file to make the tables, load the data into the tables, and then sends several queries to sql to get results. Is there a way I can … |
| | my code is working fine, but the output shows for example 12345.000 i would like to only show the data before the .000 is this posible? [CODE] Private Sub GetCurrentJanVOL() Dim con As New SqlConnection Dim cmd As New SqlCommand Try con.ConnectionString = "Data Source=" & ServerV & ";Initial Catalog=" … |
| | [ICODE]<html xmlns="http://www.w3.org/1999/xhtml" > <head> <title>PicNet Table Filter Demo</title> <script src="http://ajax.microsoft.com/ajax/jquery/jquery-1.3.2.min.js" type="text/javascript"></script> <script type="text/javascript" src="picnet.table.filter.min.js"></script> <script type="text/javascript"> $(document).ready(function() { // Randomly Create Data Rows for (var i = 0; i < 50; i++) { var tr = $("<tr>" + "<td>Value" + Math.floor(Math.random() * 500) + "</td>" + "<td>" + Math.floor(Math.random() * … |
| | Hi, how do i do this:- The dyndns that allows Admin to get result from different location. No need to get the database over from another location, able to view the report and print. Using VB.net and SQL Server 2008 |
| | Right now we're having an issue with SQL, it's currently using 1.7GB of memory, and with the size and usage of our application, this isn't always enough. The server it's on is a 32 bit Windows Server 2003 Enterprise Edition, with 15.9GB of RAM. Is there any way to break … |
| | I created the following tables and inserted few values. create table books(bookid integer primary key, booktitle varchar(20), year integer, publisherid integer foreign key references publisher(publisherid), price integer, number integer) create table publisher(publisherid integer primary key, publishername varchar(20)) create table author(authorid integer primary key, authorname varchar(20)) create table bookauthor(bookid integer foreign … |
| | Well this is what I have done so far I ran these 2 lines first, they worked: VARIABLE g_total NUMBER VARIABLE g_prod NUMBER Next I ran these 4 lines and they worked: BEGIN :g_total := 100; :g_prod := 4; END; Then I ran these and that is when the problems … |
| | Hello, I have two DataGridViews in one window. The first one displays 2 columns, itemNo and task. When I click on a row in this grid, I want to populate the second grid with corresponding material. It is organized so that the itemNo in grid1 is 1, 2, 3, and … |
| | Hello experts, My doubt is pretty simple, I suppose. But still I need assistance. I have a registration form as ASP.NET web form. There are 5-6 fields in it (username, password, email id, sex, country etc. ). I want to enter all the data, entered by a new user in … |
| | [CODE]#include <stdlib.h> #include <iostream> #include <cstring> #include <string> /* Include directly the different headers from cppconn/ and mysql_driver.h + mysql_util.h (and mysql_connection.h). This will reduce your build time! */ #include "mysql_connection.h" #include <cppconn/driver.h> #include <cppconn/exception.h> #include <cppconn/resultset.h> #include <cppconn/statement.h> using namespace std; int main(void) { sql::Driver *driver; sql::Connection *con; sql::Statement …  |
| | how to insert the values of checkbox and radiobuttons in the sql databse using vb.net??? we are getting problem in inserting and don't know what to do................ like i have one form with two text boxes named username and password and one label say gender....which has two checkboxes male and … |
| | Not sure if this is the right forum for SQL statement problems. I've searched all over but don't know how to output formatted SQL queries. Like Selecting the first letter of the first name and then last name with proper spacing. |
| | Dear All, When i execute my queries for Edit and Save for edited subject, there is no updated in my sql database. Appreciate if anyone could lend me a hand for this issue. My queries are as below. Private ConnString As String = "server=localhost; Integrated Security=SSPI;Persist Security Info=False;database=carerpt" Public Sub …  |
| | Hi, I'm having a problem on how to query from the following tables. Here are the tables. PATIENT: PK - PatientNo - FirstName - LastName - MiddleName - Address - Age FK - PageNo PAGE PK - PageNo BOOK PK - BookNo BOOKPAGE 'Junction Table PK - BookNo PK - … |
| | This is my first foray into the world of programming. I'm doing a practice project for the consulting firm I work for, and my current objective is to make my submission page textboxes insert the user input into specific tables in my database. Later I'll need to retrieve the data, …  |
| | Hi people, I get an error when performing the following request: [CODE] $query=" SELECT * FROM vessel,cargo,customer ORDER BY ladate DESC WHERE vessel.id=cargo.id AND vessel.id=customer.id LIMIT $eu, $limit";[/CODE] it is about the ORDER BY ladate DESC Can you you show me where I should write ORDER BY in the correct … |
| | Hi i have been trying to get the results for the code below and i can't seem toget myself around it. I need to get the results according to the myKad and Student Name on How many times the student has answered Excellent, Satisfaction and Poor for each question, each …  |
| | [code] <% if (this._arr_design.Count > 0) { %> <% foreach (Ameronix.Teeone.Models.Design obj_design in this._arr_design) { %> <tr> <td style="width: 254px; height: 27px;"><%= obj_design.name_design.ToString() %> <div class="thumbnails"> <% foreach (System.Collections.Generic.KeyValuePair<int, Ameronix.Teeone.Models.DesignSection> kvp in obj_design.arr_design_section) { %> <div class="thumbnail"><a href="/snapshots/processed/designs/<%= obj_design.id_design %>_<%= kvp.Value.id_design_section %>.jpg" rel="lightbox"><img src="../resources/get_image.aspx?src=/snapshots/processed/designs/<%= obj_design.id_design %>_<%= kvp.Value.id_design_section %>.jpg&width=50&height=50" /></a></div> C# … |
| | Okay, so I was originally having problems even saving the data, but I can now get it to stay in the dataset, and when I switch to another page it stays there when I go back to it. Although when I close the form and reopen it, the changed data …  |
| | Copy a table from one database to another database in another ms sql server using sql server management studio : If your table was in the same ms sql server but in another database, you would copy it using t-sql like this : SELECT * INTO NewTable FROM existingdb.dbo.existingtable; However, … |
 | hai, My requirement is given below. In my application one LOV is there to show Insured names.In that if we query for the name like ahemd's% then it is showing wrong(junk) data..................So,my question is how to add single quote to already existing single quote.........................I tried in many ways but I … |
| | This is my first foray into the world of programming. I'm doing a practice project for the consulting firm I work for, and my current objective is to make my submission page textboxes insert the user input into specific tables in my database. Later I'll need to retrieve the data, … |
| | Hello, How to save values of each and every controls to SQL database using CreateUserWizard? |
| | I dont know how to link my table to the database yet i already finished connecting to the application itself. i have four fields on the form as well in the database table. that is 1.word 2.lug_trans 3.Eng_trans 4.meaning the same fields appear in the database tables. i have to … |
| | Hello world, I need your help/advice, I have a table last_acces where inserting a few data. The table columns are: Id Name Date I want to export this data into excel clicking on the link or button from the page. Anyone could help me on this please? The action will … |
| | Hi everyone, I have a huge problem with importing data into Microsoft SQL server 2008. First of all I have created the database with the foreign keys etc. And now I want to import data. I have used BULK method i.e. [CODE]BULK INSERT tablename FROM 'c:\tablename.txt' WITH ( FIELDTERMINATOR = … |
| | in a table having the fields of starttime & endtime ,I want to fetch only the records having starttime & endtime of same days.  |
| | create table #TempRouting( id int, routetype char(4), routesequence int) insert into #TempRouting (id,routetype) values (1,'MON') insert into #TempRouting (id,routetype) values (1,'MON') insert into #TempRouting (id,routetype) values (2,'MON') insert into #TempRouting (id,routetype) values (3,'MON') insert into #TempRouting (id,routetype) values (4,'MON') insert into #TempRouting (id,routetype) values (5,'MON') insert into #TempRouting (id,routetype) values … |
| | Hello guys. I need information abaut of java conetion SQL sever 2008. Thanks |
| | Can anyone tell me whats wrong with this code? It throws this exception: A call to PInvoke function 'Web!Web.SQLiteBase::sqlite3_open' has unbalanced the stack. This is likely because the managed PInvoke signature does not match the unmanaged target signature. Check that the calling convention and parameters of the PInvoke signature match …  |
| | Hi, I have the following data in a excel csv file: Date,Time,TempOut 3/17/2011,00:30,73.3 However, if I load it using: [CODE]ExclConn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + dir + ";" + "Extended Properties=\"text;HDR=Yes;FMT=Delimited\"";[/CODE] Then: [CODE]string Data = "SELECT * FROM [" + FileName + "]"; OleDbDataAdapter dtadpt = new OleDbDataAdapter(Data, ExclConn); …  |
| | I have two tables: CDDemographics and CBTechProviderData. Both have 200,000+ rows. A common column between these tables is CensusBlockID, of which the first 5 integers are the fips code - in this case I am defining that code as 55001. I am trying to sum the population of CensusBlockIDs where … |
| | I'm trying to run the following code but get a casting error. How can I rewrite my code to achive the same ? [CODE] boolResult= (bool?)dataReader["BOOL_FLAG"] ?? true; intResult= (int?)dataReader["INT_VALUE"] ?? 0;[/CODE] Thanks |
| | I have 2 tables, MPW1400 LeaseRecNo PropNo BldgNo UnitNo LeaseStartDate MPW1482 LeaseRecNo EffectiveDate AnnualAmount CertNo My Objective is to get the total of 'AnnualAmount' Where MPW1400.LeaseRecNo = MPW1482.LeaseRecNo and CertNo = '1' Example: MPW1400 ------------------------------------------------------- LeaseRecNo | PropNo | BldgNo | UnitNo | LeaseStartDate ------------------------------------------------------- 12345 | RG52 | 24 … |
| | I have a view that pulls in a field, the feild has data in the following format. A1-an987389 B21-At081l0 AA1-ath01882 how would i get the infoamtion before the "-" IE A1 B21 AA1 the size of the data before the "-" can be anything from 1 up 5 charcters i … |
| | Hi, I have replication configured on a SQL 2008 Database. The tables involved are something like this; [INDENT]tbl.Product ProductID Int ProductName NVarchar(max) ImageID Int FK_Product_Image FOREIGN KEY(ImageID) REFERENCES tbl.Image (ImageID) tbl.Image ImageID Int Image Image[/INDENT] tbl.Product is part of a Transactional publication with updatable subscriptions. tbl.Image is part of a … |
| | I have a program that works access 2003 and i convert tables to sql Server 2005, but the problem is that program works only on the server but does not work on client .the internal network is workgroup and system is Windows XP . what can i do to get … |
| | hey there, I am doing testing to my site and i need to make over 60 rows to check paging. Is there any possible way to just copy rows over and over again? Thank you, |
 | |
| | |
| | hi guys i have developed a simple application to insert data in to a SQL DB and get data from same DB using stored procedure. ( 1 table ,2 SP's ) so now i want to run this application on my friends computers to. so how to transplant my simple … |
| | Anyone want to help me with this SQL-code? [url]http://pastebin.com/VWnJmM34[/url] I want to add a column that shows the number of cupcakes the customer bought for that specific order_date. Is this possible? How do I do it? |
The End.