6,934 Topics
 | |
| | I have the following sql statement in VB6 (latest VB SP, Win XP, SP2) that works fine in ado to sql server 2k5 but does not work in ado to access 2k3. [B]"Select ID, Make, Model, PlsPerBBL, Size, Processor, Location, From MeterData Where MeterNo = 'FQ-805 8" IN'"[/B]. I know … |
| | Hello, I created this site on my local machine using PHP 5.0.4 and mysql 4.1 and it works perfectly fine. I then ftp it to my webhost but the code to retrieve values give me this error. Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/www/laterallinks/ApplicantInformation.php … |
| | I have looked at the syntax of SQL/XML query and tried to run a sample query. But not able to write my query using it. Can someone provide a tested and working SQL/XML? |
| | i have made a simple login page with 2 textboxes for username and password and a button to login. the usernames and passwords are in an sql database . how would i go about retrieving the username and password from the database. i have tried a select where statement If …  |
| | Hi, I have two table like this: [QUOTE][B][COLOR="Red"]quote_tb:[/COLOR][/B] [B][U]ID item vendor quote[/U][/B] 11 a v1 100 11 a v2 200 11 b v1 400 11 b v2 300 11 c v1 555 11 c v2 777 22 a v1 122 22 a v2 222 22 b v1 322 22 b … |
| | i want the insert statement in jdbc for the following name gs al ts madhu 1000 500 sud 2000 600 now i want to access gs and al from the database table by using select statement now i want to add gs and al like totalsalary=gs+al; now i want to …  |
| | How do i store images in the database and retreive them in vb.net? Please help.... Thanks in advance |
| | today i came across to an sql problem from one of the threads in the database forum : to solve the problem i created a table named "names" having these columns : PKID | name | lastname and i entered some rows having the same values for name and the … |
| | I am trying to implement an example of the built in login and createuser wizard. the ony problem is, (and this may be really retarded of me) is that when i publish it out to a web server it doesn't work. Of course, it works perfect locally. Does the aspnetdb.mdf … |
| | hi everyone, I need to know what are the services that sql server has. e.g. reporting etc. can you guys give me a list of these services. thanks  |
| | i am getting a problem in updating my database. actually i am accessing two colums from my table and adding these two numbers , and the result i want to insert in the tables 3rd column The statement i am using to access two columns String str="select * from emp" …  |
| | Hi, Is it possible to install SQL 2000 and SQL 2005 server on a single server? If yes then will it create any problem? Thanks, Kailash  |
| | In Turkey we use "." as thousand seperator and "," as decimal seperator. If you are working with currencies in sqlserver, and if the money columns is of type "money" then the problem occurs beause of the seperator issue since in its default mode sql server accepts "," as thousand … |
| | sql cache dependency allows for cached data to be evicted and refreshed when it becomes stale. Basically ASP.NET checks for the changes in the datatable in sql server, if it finds one, it refreshes the cached data. Polling based sql cache dependency is very easy to configure as follows : … |
| | Hi, currently I have a shared web hosting with MS SQL server 2000 database. I have already implemented the database, with all the data inside the database, on the server. Now I wish to copy the whole database (.mdf) down to my PC, in case I wanna change hosting or …  |
| | hi i want to fetch username from another table based on the id generated in the temopary table. [CODE] <?php @ $rpp; //Records Per Page @ $cps; //Current Page Starting row number @ $lps; //Last Page Starting row number @ $a; //will be used to print the starting row number …  |
 | Hi, I have one question related to SQL Server. But there is not forum on this. so here is my Question. While accessing multiple columns value in a single alias column we right query as follows. [CODE] Select FNAME +' '+ MNAME +' '+ LNAME as NAME from Cust_Master [/CODE] … |
 | hi all I have a connection to a sql d/b that loads data into a gridview. now in this grid view I have edit buttons that process user onto the 'edit' page (a separate page). the data from the row that was selected for editing was sent to the next … |
| | hi there guys ,, im have just a idiot asking ,, i have sql server 2005 express but im confusing for data work , where can i install that , into server or client , or both>>.??? i know how to basic program in SQL but configuring its merely little … |
| | Hi, This is an interesting question (in my humble opinion). I am trying to create a forum in PHP. So there is a "Post a new Thread" link, clicking on which would open a textarea field for posting a message and a textbox for the "title". Now, I dont want …  |
| | I have a need for a program better than Query Analyzer, I use Enterprise Manager on a daily basis for work purposes and have given the Query Analyzer program to our head person in charge of the front-end of the software, but they are now having a growing need to … |
| | Well n not a mysql expert so i need help with this sql file here r d contents of it. Quote:[code] CREATE TABLE `admin` ( `id` int(11) NOT NULL auto_increment, `username` varchar(255), `password` varchar(255), `webmaster_email` varchar(255), `lastlogin` int(11), PRIMARY KEY (`id`) )"; "insert into admin set username='$admin_login',password='$admin_pass',web master_email='$admin_email'"; CREATE TABLE … |
| | In my website, i want to accept photos from users(through HTML page) and save them to database(MS SQL) Can you please tell me, how can i do so? Also tell me how to retrieve those photos back from database to HTML page or JSP. Thank you.  |
| | HI I am software tester and want some small project which made in MS-sql server 2000 for the testing even if you have some corrupted file (not virus infected)please provide me . THANK YOU |
| | I am currently trying to export data from a excell db to a vb.net and create some for loops so I can generate data from it. anyway I got the whole thing working apart from I cant get the list box to show all the data in the column instead … |
| | Hi, I'm looking for help with this. I'm tring to get an image back from my SQL Server Express database. The code below is where I'm calling the stored procedure from. If I leave out the IF STATEMENT and WHILE LOOP I'm getting an error saying it's trying to read … |
| | I am writing a program in VB 2005 Express and I am using SQL to insert, delete, etc. I was curious if there was a SQL statement that would allow me to backup the database in Access - I have tried the MySQL syntax for it, but I can't seem … |
| | hiii,,,i m using asp.net 2005 and sql server 2005 i m using gridview and sql datasource,,whn i debug the application i get ths error:::: ________________________________________ Format of the initialization string does not conform to specification starting at index 0. ___________________________________________________ can ne1 help me out with ths error,, thnks in … |
| | I have below query inside sp. select groupno,a from table1 where groupno <> 'Test' It is not returning rows where groupno is null. I did recompile sp with SET ANSI_NULLS off. But it is not working. Any suggestions? Please help thank you  |
| | Hey, all Java and JSP gurus, Please help! In my website (created using JSP and MS SQL), i'm accepting resume from users in .doc format. Can you please tell me- how to save it in my folder from web-page i.e. the "browse" and "upload" code. (mine is a mock site … |
| | how would one go about loading up sql data into an asp.net (without using dataview, formview, detailsview etc)? any ideas? have my table marked up already and connection strings just need to know how to put the two together. Thanks for your time |
| | Hello, I am new to SQL. I assume that this is very simple. I have had trouble understanding the relevant example in the BOL as my installation (Express edition) does not seem to have the adventureworks database that is so ubiquitous in the examples. Say I have two tables, Test1 … |
| | Hi I've populates a DataGridView from the results of a SQL query programmatically, so I haven't had to define the number of columns, etc. Just before I display it, I'd like to change the columns with Yes/No in them with checkboxes. Any ideas how I can do this programmatically? Regards … |
| | I've mentioned SQL Injection attacks a few times in this forum and the Database Design forum. From the responses I got, many folks here don't know what an SQL Injection attack is. If you do any SQL interaction via a web-based interface, do yourself and the Internet community a favour … |
| | Hi I am trying to teach myself some php and get this error (below) when I query a sql database this is just a tutorial and will never go live. I have hilighted the area in bold where the unseen error is. Warning: mysql_fetch_assoc(): supplied argument is not a valid … |
| | Hello, I am trying to use the sql delete from statement to delete certain data (which are urls) from my db, but they don't seem to actually get deleted. (there are no errors, of course, so it looks like the code is working, but the data does not actually get …  |
| | I have a database in SQL Server 2005.I've a table namely 'PersonalDetails' in it which contains a 'date of birth' field of type datetime.I've to generate weekly birthday reports . I wrote a sp like this:[code] ALTER PROCEDURE [dbo].[selectweekfrompersonaldetails] ( @paramdate datetime ='02/01/2007' ) as -- select EmpID,EmpName,month(DateOfBirth) bmon,day(DateOFBirth) bday … |
| | i have these 2 sql for creating 2 tables in my database, what i have to write to show that is one to many relationsip? [one supplier to many order status] CREATE TABLE Suppliers( SupplierID nVarChar(10) NOT NULL CONSTRAINT Suppliers_PK PRIMARY KEY, CompanyName nvarchar(40) NOT NULL, Description nvarchar(100) NULL, SortOrder … |
| | $result=mysql_query("select employer.employer_id,employer.companyname,post_job.jobtitle,post_job.owner,post_job.tdate,post_job.id from post_job,employer ORDER BY tdate.post_job ASC LIMIT 0,10 ") or die("ERROR:".mysql_error()); it is not working..........  |
| | Hi there! I've developed a program in C# that calls a stored procedure in SQL server. Is it possible for a stored procedure to pass back a result set with multiple rows? If so how do I access these values in my application. Many Thanks! |
| | I have Used following code to Insert Values in the table: <%@ Import Namespace ="System.Data" %> <%@ Import Namespace ="System.Data.SqlClient" %> <script runat ="server" > Sub Create(ByVal obj As Object, ByVal e As EventArgs) Dim ConnString As String Dim SQLstr As String ConnString = "Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ERL.mdf;Integrated Security=True;Connect … |
| | First hello to every one in this forum. Well I am using MS Access 2003 for building a database. [B]I am usign 3 tables.[/B] [LIST=1] [*]Students [*]Books [*]Request [/LIST] Both student and books table has one to many relation with request table. I am using MS Access Forum for all … |
| | Hello all, this tools is used to load CSV files to SQL server table. all the tools that i found on the internet are not free, i have developed this tool so it can help you. regards download link here: [url]http://www12.sendthisfile.com/d.jsp?t=J8hEGXcRYqej3qrjku3N63Eh[/url] |
| | I am new to SQL and I am making an asp.net page in which is a small airline service for a project for scool. For one of my tables I have: AccountID, CustomerName, FrequentFlierMiles, FrequentFliernum for my column names. The acount AccountID column can not have duplicated values and FrequentFliernum … |
| | we recentely migrated our database from 2000 to sql server 2005.The migrated database has some issues like collation issues,so we created the scripts for each databases and then updated these scripts to remove collation issues to make these compatible to SQL server 2005. But we have some permission issues for … |
| | Hello, I have a vb.net application that runs on a server. There are five client PC's that are connected to the server and all the data is saved on the server from my vb.net application. To add a record, two sql runs under Commit transaction. One runs an insert statement … |
| | First I will show you my sql, just in case it is some obvious syntax error on my part: [code] "INSERT INTO tblResults(status, enthusiasm, communication, knowledge, interaction, organization, responsiveness, instID, comment)" & _ "VALUES(""" & status & """, """ & enthusiasmB & """, """ & communicationB & """, """ & … |
| | want to know the coding of h ow to define connection of SQL database wid deplhi so that i can insert data in database |
| | |
| | Hi all. just wondered if there was a quick and easy way (or good tutoriaL) to validate user input (on a login control) against a SQL database where the users username and password credentials are stored. Any suggestions will be greatly appreciated! Thanks for your time. |
The End.