2,570 Topics
 | |
| | I return 30 tables or so from sql in a stored procedure. In the stored procedure I select these tables via... [CODE]select * from myTable1 select * from myTable2 select * from myTable3[/CODE] etc. These tables lose their sql table name when returned in a dataset and have default names … |
| | Looking for an answer about how I can use relations in my DB, when a link is clicked. I have the main navigation in the top of the page, the table is called:"SUBJECTS", primary key is ID. I also have a local navigation in the left side of the page. … |
| | This is old college assignment am doing to sharpen my sql skills, its cat test centre and this funtion is checking if the mechanic is available on certain date which is input from user in the anonymous block. the problem i m having durning testing is that the function result … |
| | I am getting the value of a datetime picker and add it in the database but it is throwing an exception saying : [COLOR="Red"]The conversion of a char data type to a datetime data type resulted in an out-of-range datetime. The statement has been terminated.[/COLOR] This is my SQL Statement …  |
 | Hi Everyone, I have this problem. I am done with the coding, and I want to access it using a url. The program is working perfectly in my local computer, but when I try to go to IIS, add a new website, assign port, like what I did in my … |
| | I am creating a cms, where I have a Global horizontal navigation(SUBJECTS) in the top, and a local navigation(PAGES) on the left, all database driven. First I decide if either a subject or a page has been set, to display the correct information: [CODE] if (isset($_GET['sid'])) { $subjectid = ($_GET['sid']); … |
| | Hi everyone, I am new to this board. I am trying to figure out how to set up an SQL statement to grab a record from a database when I'm not sure what column/field the string I am looking for will be in. for instance: I am looking for "ABCDEFG", …  |
| | I keep getting the following error when I try to add new record into database (Access 2007) "The INSERT INTO statement contain unknown field name:'login'." I dont whats wrong as the coding looks fine and the field login does exist in the database. Spent whole day trying to find the … |
| | Hi all, I have had a look around the forums but i could find anything, if someone could point me in the right direction for this. What is the best way to handle an sql connection, in my program I have to get data from the server on a button …  |
| | I am designing a website that connects to a database. I am using wampserver to connect to the website. In my customer add page I am trying to ask the website to generate an autonumber from the database. As my table in the database is set up as following: [CODE=SQL]CREATE … |
| | Hi guys, I'm trying to build a query that involves two tables, the course table and the studentsLink table. The StudentsLink table describes the link between students and the course. The tables are as below; Course courseID(bigint) - PK courseName (varchar) courseInstructor (varchar) StudentsLink courseID(bigint) - PK StudentID(bigint) - PK … |
 | i have the following code [CODE] Dim i As Integer i = Me.GridDomains.CurrentRow.Index Me.lbdomainid.Text = GridDomains.Item(0, i).Value [/CODE] when i have complied it in visual studio 2010 (debug) i get a error saying system.data.sqlclient.sqlexceptions conversion faild when converting varchar value LBdomainID to data type int. in sql the datatype is … |
| | Dear All , I need to backup the sql server 2005 express database . It works fine if I make backup to specific folder"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup" . But if I change the path to any other path . I got an error "Backup failed for Server 'server name'. " … |
| | I've looked all over the internet for a suitable solution to my problem, and I just can't fine a simple and effective one; so I hope I can get some help here! First off I am programming a hotel booking system for my college computing project. This consists of a … |
| | Hi Guys, Not sure if this is a php or sql problem but i keep getting the following error when trying to update a row using php and 'UPDATE': ERROR:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right … |
| | I am trying to create a view and by linking two tables together, VLP_QC_Results_Batch1000 and VLP_Stock_QC1000. (see below pics) The issue I have is in the VLP_QC_Results_Batch1000 has the testNo within a field called TestNoName and is separated by a “-“ I need to link these so that we can …  |
| | Hello everybody and thank you in advance for taking the time to read this. I am having trouble connecting to a remote MSSQL server from our web page server using the SQLSRV Connect. I have installed all the necessary php extensions and sql drivers, and they all appear as they … |
| | Hi, I am new to ASP.NET and i have been thrown into the deep end on a project, the person who created this code is no longer available. The website allows an Admin to login and edit, update or delete information in an SQL database referring to PDFs located on … |
 | 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 … |
| | Hey guys i d like to pick your brains about something.. Suppose i want to create a database for storing, lets say computer stuff, parts, hardware, peripherals etc.... Which way would be better? 1 ------ Create a Basictable with all the common fields (like ProductName, Price,Guarantee....) and then create multiple … |
| | i have the following code which works fine where there is data in the table. when the table is empty and there is no data in the @Ctotal varible i get my error MessageBox.Show("Unable to get Claim Total") is there anyway i can ignore this if there isn't a value … |
| | i have a very simple S/P called ClaimTotal [CODE]CREATE PROCEDURE ClaimTotal @Result varchar(50) OUTPUT as select sum(total) as Ctotal from claim[/CODE] i am struggling to get the Ctotal saved into the @result so that i can then pull this into my .net program. if anyone could help that would be … |
 | 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, 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] … |
| | 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 |
| | 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 … |
The End.