6,934 Topics
 | |
| | Hi I have used a tutorial on full text search which was brilliant...I now want to add in pagination to it....Bu ti can;t seem to work it from the pagination tutorial... This is the code for my full text search... <html> <head><title>Search</title></head> <body> <?php // Database Connection include 'db.php'; // … |
| | I am relatively new to all of this, but I have a form on my website that emails the results to me. It is using an asp file from my host. I also want to connect to the database hosted by my provider and record the data there. If you … |
| | Hi all, I am writing a web interface which uses a MSSQL Server 2000 database. I have checked and double checked all permissions and can't find any problems but when I run a [code]select * from sales[/code] I get the 'Permission denied for `sales` database `dbasename` database owner `sqluser` I …  |
| | [COLOR=#434343]Hi all, I would like to seek for some help from you on how to create a connection to a sql server database which is host on web with my local VB6 program. I appreciate if you could provide me the relevant information about that with some sample codes. Thank … |
| | Hi, I have a database with 15 tables and couple of queries created in SQL Server 2005 and I am making a form/interface for the database in Visual Basic .NET. I managed to connect the tables by using the BindingSource / DataGridView controls. However I cannot find the queries in … |
| | Hi, I have a small database with 15 tables and 20-40 records in each table. I just want to ask how can I print all the tables together with their names, atribute names and all the records? (the Print option from the File menu is not active) Thanks, Robert |
| | Hi, I have a database with 15 tables and couple of queries created in SQL Server 2005 and I am making a form/interface for the database in Visual Basic .NET. I managed to connect the tables by using the BindingSource / DataGridView controls. However I cannot find the queries in … |
| | Hi. I have just installed 2005 in my on my database server. Now, I have a web server and will need to access my database from my web server for simple stuff such as querying the database and checking tables, etc, etc. What should I be installing on the Web … |
| | Hello all, Is there any algorithm to convert a python tuple to MySql query. Ex: [B] ('*','name','sliver')[/B] should convert to [B] select [Pri_Key] from [All Tables] where 'name' = 'sliver';[/B] I have been able to do so ... but my algorithm looks very ugly and have to process everything bit … |
| | Hi, i have 2 tables. i have 3 equal colomns in both. I want transfer all data from 1st table to another one. How can i do it? Thanks this doesn't work but something like this; insert into exam (e_score, l_name, s_id) values (dbo.assignment.e_score, dbo.assignment.l_name, dbo.assignment.s_id) |
 | When i make click on signout i m destrying the session object by session.abandon qith modifying the database with status = offline.. Bt when IE is closed directly without clicking on signout session object get destroyed bt the real problem is that [B]how to update SQL Server database as session …  |
| | Hi i basically new to visual c# and i want to create a stock portfolio program to store my stock information, i have decided to use SQL server 2005, but i'm not sure if i should use mangement studio that comes with sql server to create the database or a … |
| | I'm attempting to upgrade an Access database to use a SQL Server 2000 back end. I have installed SQL Server and created a DSN. However, when I attempt to link to the SQL Server database from Access (File/Get External Data/Link Tables/Select ODBC Databases) nothing happens! Any ideas what I'm doing … |
| | I have created the following stored procedure in sql server 2005.I m using asp.net with C# 2005. Can someone please rectify my errors why i m getting such type of the errors... [code] ALTER PROCEDURE CompanyStoredProcedure @uspcompanyid INT NULL, @uspcompanyname VARCHAR(20), @uspaddress1 VARCHAR(30), @frmErrorMessage AS VARCHAR(256) OUTPUT, @RETURNVALUE AS INT … |
| | Well, whenever I try to run a user verify script, that asks SQL if a username is not taken, I always get this response... [quote][B]Warning[/B]: mysql_num_rows(): supplied argument is not a valid MySQL result resource in [B]dir/userver.inc[/B] on line [B]11[/B] count unavailable[/quote] this is the code in general: [php]<?php //User …  |
| | Hi, i'm new to all this. I'm really stuck!! I'm running XP Prof and have recently installed SQL Server 2000 Personal edition. It seems to have loaded in ok,,BUT,,it won't connect to my localhost,,i don't know what the problem is i get the 1069 error message. Pleaaaaasssee can someone help … |
 | I want to install SQL Server agent using [B]Setup Factory 7[/B]. Can anyone please help me on how exactly I can do this? (I am installing a VB6 program that must access data from SQL Server 2000, so I want the setup to: 1. Install the SQL Server part. 2. … |
| | Hello friends, I am looking for the javascript for sqldatabinding with Select dropdownlist in ASP.NET. I want to populate HTML Select dropdown with my sql query. How can i do this? Thanks in advance. Snehal  |
| | hai guys, I am a newb in SQL server. yesterday i have installed microsoft sql server 2000 to my computer. But i don't know how to employ this. I have a group of ASP pages that contains my MBA assignment notes and files, and is successfully working with IIS in … |
| | [B]Any expert can solve this??[/B] Error message will occur during execution, is something related to sql. the program will show an error on objcommand.executeNonQuery. Can solve this? Imports System Imports System.Data Imports System.Data.SqlClient Public Class Form1 Inherits System.Windows.Forms.Form Dim objConnection As SqlConnection = New _ SqlConnection("server=(local);database=uni;" & _ "Integrated Security=True") … |
| | I am using a ADODB connection to connect to an access database and am using an SQL string as the comandtext....but i need to check the validity of wat i have typed.....here is the sql statement.. [code] dim cmdcommand as new adodb.command With cmdCommand .ActiveConnection = conConnection .comanttext = "select … |
| | hi help me out. i get error msg when i try to "Test Driver Connection" from WebLogic 8.1 with SQL Server 2000. do i set any privileges from SQL Server for WebLogic 8.1 server to eastablish connection. Thanks in advance Deborah D  |
| | is there any way through which we can generate reports in mysql. not using any s/w but coding. if yes plz tell me Thanks |
| | Hi, I am using Oracle 10g Express Edition on Fedora core 5 32+ bit os. The problem is when I use the SQL Plus command line to make SQL statements I can not get the previously typed command back at the prompt when I use the up and down arrow … |
| | I'm creating a web application in VB.NET 2003 that connects to a [URL="http://www.daniweb.com/techtalkforums/post334786.html#"]SQL database[/URL]... how do I display the data in separate controls (TextBoxes, labels, etc) instead of in a data grid? Thanks, [URL="http://www.daniweb.com/techtalkforums/post334786.html#"]Windows[/URL] 3.11 |
| | I'm creating a web application in VB.NET 2003 that connects to a SQL database... how do I display the data in separate controls (TextBoxes, labels, etc) instead of in a data grid? Thanks, Windows 3.11  |
| | I am new to ASP.net as of today :) I have jumped many hunrdles alreday, writing/deleting text files, connecting to a db, sendiong emails, yeah me. I am looking for 1 concise example to show how i can take the contents of a form and insert them into a datbase. … |
| | i can't see where is the Invalid character with the SQL statement below. i can't see where i miss any character or i added extra characters. mySQL = "UPDATE table SET col1 = '"_& rA & "', col2 = " & rB & ", col3 = " & rC & … |
| | Forgive my ignorance, I am new to RDMS and SQL both. My question is this: I have 2 tables, one a primary table and 1 a relational table table 1 has ten rows valued 1,2,3,4,5,6,7,8,9,10 table 2 has 4 rows keying from table 1 row1 = 1 2 row2 = … |
| | Hi, I have a excel sheet "Biodata.xls" (already containing data). I need to load this data to a table "Details " in sql server. I have done it using the DTS wizard. Is it possible to do this through some code in c#? Can somebody help me out....... Thanks, Aswathy |
| | On Page One of my application, I have a dropdown list that populated by a SQL query. The list displays the "Text" of the items on the list, but the values (that will be passed are the indexes from the database table) . The user can select multiple items from … |
| | Well, Iam using asp and sql server to store data in database. I have a work to show data to all users. But data is very fast and it must update in a second... so im updating it in a second on a webpage....but ofcourse on internet, it disappears before … |
| | I'm having a problem querying data from two different databases on a SQL 2000 server. We have two databases, a main data db, and a separate security db that has login info. Database logins for the data db DO NOT have access to the security db. I have a function … |
| | [COLOR=midnightblue]The INSERT statement conflicted with the FOREIGN KEY constraint "FK_yaf_Forum_yaf_Category". The conflict occurred in database "yafnet", table "dbo.yaf_Category", column 'CategoryID'. The statement has been terminated. How to solve this error...........[/COLOR] |
| | Hi, I am designing a small advertisement management program in asp, and Sql Server 2000 as database. My table has the following fields which are pretty self explanatory: bannerId, bannertitle, bannerurl, imageURL, bannerpirority bannerId = Autoincrement to generate unique id for a banner ad bannertitle = String title of the … |
| | Hi.. I've problem here. I have checkbox chkdrugnegative..user can select more than one drug name. my problem is how to insert to database. how the table. i'm using pl/sql. here is my sample coding. Private Function adddrugtest() As Integer Dim oleConn As OleDb.OleDbConnection Dim roleData As OleDb.OleDbDataAdapter Dim oleCmd As … |
| | [COLOR=midnightblue] Hello All, Apologies if this is the wrong forum section. Some help and advice please regarding a [URL="http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=19631#"]SQL[/URL] Report. It is for a Feedback form and below is a quick mock up of the DB diagram [IMG]http://img219.imageshack.us/img219/4102/feedbackbr8.jpg[/IMG] tblFeedback is populated with a [URL="http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=19631#"]Customers[/URL] details and the tblResults with the … |
| | Hi: I'm writing a VBA macro in xls to chart various records that I'm querying from MS SQL. One of the values that are most important for me to chart is the total number of records. The way I have the xls code, I can pull the data into xls … |
| | Hello, I was looking around for some tutorials about how to backup my database in my hard disk using [B]SQL Server 2000 Enterprise Manager[/B]. Can someone explain me in a friendly and step-by-step method? (screenshots preferred) Thanx so much in advance |
| | Hi: I'm writing a VBA macro in xls to chart various records that I'm querying from MS SQL. One of the values that are most important for me to chart is the total number of records. The way I have the xls code, I can pull the data into xls … |
| | pls help me to do this in C#  |
| | Can someone please show me a code syntax on how to update an SQL database programmatically ( execute on click of button). I want to get all records from the "Student" database table where StudentStatus = 'New'' .Find a particular RegDate (2001/02/02) , StudNo ( 200144176) and update it's StudentStatus … |
| | Hello, I am using ASP and MS SQL Sever 2000 as backend database.. I am writing a SQL query which will pick up top 5 recipes details who have scored the highest marks from the following table tblrecipes - [code] ID | recipe_name | Total [/code] [u]The following points to … |
| | i am trying to install the ms crm trail version and i keep getting err msg " The minimum required version is SQL Server 2000 SP4 (8.0.2026)." i already downloaded the sp4 with all its components updrade and my sql version is 8 but i need it to be 8.0.2026. … |
| | can anyone tell me the coding for creating a sql table programatically in vb.net |
| | Hi,I want to save a picture in a database(SQLserver2005) and use it the picture in a web form by binding to a control how can I do it?  |
 | [B]Intro[/B] I'm not the best at this, but I thought we were lacking a SQL tutorial... [B]Test table[/B] My Little Test Table called "test" for this great exercise contains the following [B]FirstName[/B] [B]LastName[/B] [B]EyeColor[/B] Paul Esson Brown John Smith Blue John Howard Green Kim Beazley Gray [B]SELECT[/B] This selects data … |
| | hi I am working in asp.net but new to xml q: I have some data in xml format. I have to convert the data to SQL table and display the data in web page through gridview through coding. the problem is as i am new to xml I dont have …  |
| | I have a problem creating a ODBC connection. I am using MS SQL server 2000. Local access. I create it in System DSN. 1. I select the "With SQL Server authentication using a login ID and password entered by the user rather than Windows NT. But the error message occur … |
| | This is to do with this posting :- [url]http://www.daniweb.com/techtalkforums/showthread.php?p=59153&posted=1#post59153[/url] The problem seems to have stopped, but I am woindering if there is anything else I can do. Thanks very much Logfile of HijackThis v1.98.2 Scan saved at 03:11:12, on 09/10/04 Platform: Windows XP SP2 (WinNT 5.01.2600) MSIE: Internet Explorer v6.00 …  |
The End.