9,022 Topics
how can i display the scope_identity() in a textbox on a web form. also, how does scope_identity work when trying to pass a primary key from 1 table to another?
Hi All I am hoping you may be able to help me with a general query I have, I am working on a small script to query our MSSQL database, it is basically a database of search terms, i.e. Term, Date help me, 22-10-2006 searchfor, 22-10-2006 What I want to …
Hi all, I have a problem with an SQL-query and I don't know what the best solution would be to solve the problem. [code] /*INSERT INTO WERKS ( WERKS.Z8601, WERKS.Z8602, WERKS.Z8603, WERKS.Z8604, WERKS.Z8605, WERKS.Z8606, WERKS.Z8607, WERKS.Z8608, WERKS.Z8609, WERKS.Z8610, WERKS.Z8611, WERKS.Z8621, WERKS.Z8622, WERKS.Z8623, WERKS.Z8624, WERKS.Z8625, WERKS.Z8626, WERKS.Z8627, WERKS.Z8628, WERKS.Z8629, WERKS.Z8630, WERKS.Z8631, …
Name: Pam Nicknames: MsLemony, lemonflower, PJ, shorty Hair: Brown Eyes: Hazel Age: 53 Location: Missouri Hobbies: Fishing, Computers, and Sewing Education: A.A.S Computer Information Systems Favorite Movies: French Kiss, Life of Bryan, Seven Year Itch, Nanotchka Favorite TV Shows: Big Love, Seinfeld, ANTM, So You think you can dance, House, …
Hi All, I have a stored procedure which displays list of ADMITTED,QUEUED and DISCHARGED patients. The patient status is stored in a table. A represents ADMITTED patient, Q represents QUEUED patient and D represents DISCHARGED patient. I am using a dropdown to display the ADMITTED,QUEUED and DISCHARGED patients respectively. I …
Hi all, God Bless U, [B]Thursday, October 19, 2006[/B] [COLOR=red][B]first i am writing the my problem again......:!: [/B][/COLOR] i am facing a problem in SQL Server. I am have a table given below.. ------------------------------------------------ Table name is "A" ------------------------------------------------ 1 Michle Administrator 2 John Consumer Finance Officer 3 Jackson Employer …
Hi all,:confused: God Bless U, i am facing a problem in SQL Server. I am have a table given below.. ------------------------------------------------ Table name is "A" ------------------------------------------------ 1 Michle Administrator 2 John Consumer Finance Officer 3 Jackson Employer 4 Goeffery Empl0yer ------------------------------------------------ Here the identity column is the first one. Now …
Hello Everyone, I want to write a code in ASP where on a button click, a function(wrtten in eighter java or vb script) will be called . The function will execute a stored procedure which will be used to insert and delete records in a SQL database. I wanted to …
hi everybody, currently im developing a website for my final project and im a beginner for asp.net. I want to display information from database to my dropdownlist page on page load.it works but i want to dislay only distinct information from the columns of the table how can i do …
Hi, how can i retrieve information from ms sql server using vb.net 2003 when i enter my id in my field? can somebody help me with it.. thanks..
Hello, I am developing a embedded system that needed to appear as a computer on a windows SQL server. This is being done to share files from the embedded system to the SQL server. Is it possible to make my system a file sharing computer?
[COLOR=navy]Hello, this is my first post, so thank you in advance for any help you may be able to give! [/COLOR] [COLOR=navy]I have an ASP page that I need to have pull some information from a SQL table and display. The query in question is very simple: [/COLOR] [COLOR=navy][code]rs.open "SELECT …
[B]Intro[/B] Here is how to set up Microsofts MSDE for personal development. [B]Getting started[/B] Download the MSDE from: [url]http://www.microsoft.com/sql/downloads/2000/sp3.asp[/url] Select 'SQL2kdesksp3.exe' and save it to your computer. Double-click on the SQL2kdesksp3.exe you downloaded. Once you have run the self extracting exe (SQL2kdesksp3.exe), go to a command prompt. Start > Run …
Hi, I've got a problem with searching for record(s) that match the staffID in my "Staff" table in the database. I have a string named mstrSql, a txtStaffID text box and a sql statement that goes [code]mstrSql = "Select * from Staff where staffID like '" & txtStaffID.Text.Trim() & "%" …
Hi, I'm trying to use a Do Loop to look at 2 seperate tables. It needs to check the value in one field on the first table. If it finds a "T" it should look to a field in the other table and count down 3 rows. Then it needs …
Hii All, I havea problem with uploading Images into Database(MS Sql2000).. and i want to retrive them back.. Please do favour to me..
Dear All how can i connect my ASP page to SQL server database in a local machin i get this error Running connectivity tests... Attempting connection [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. TESTS FAILED!
Hi Folks, I'm working on a small application that interacts with a sql database. I've managed to pull a list of customers (Company names) from the Customer table and populate a combobox. Now I'm trying to populate some textboxs or labels with the company address from the same database based …
##USING:ORACLE 9i For each of the following tasks, determine (a) the SQL statement needed to perform the stated task using the traditional approach and (b) the SQL statement needed to perform the stated task the JOIN keyword. A list that displays the title of each book & the name and …
Hey guys..... can someone tell me why when I pass a NULL value to this function, the logic comes back as NULL and not an empty string?...... Thanks, Ken [CODE]Public Function Field2Str(strValue As String) As String If IsNull(Trim(strValue)) Then Field2Str = " " Else Field2Str = Trim(strValue) End If End …
hello everybody; [COLOR="Red"]this is my code [/COLOR] [CODE]<% Dim sqlstring dim objConn set objConn = server.CreateObject("ADODB.Connection") 'objConn.ConnectionString ="DSN=ostad.dsn" objConn.open("ostad") sqlstring = "SELECT * FROM ostad" If Request.Form("TypeSearch") = "lname" Then sqlstring = sqlstring & " WHERE lname LIKE '%"& Request.Form("DaInBox") & "%'" End If If Request.Form("TypeSearch") = "skill" Then sqlstring …
Hi, Is there any freeware to convert mdb format to mdf format? When converting mdb to mdf, why does it keeping prompting for server name , then user then password. Even thou i'm converting it from local server....without having to use the lans connection. Is there any other way of …
Hello everyone, This is my first post on this board, I have a problem that I cant find any answers for on the web. I have a Private sub on a form, and I have sql code that draws the information that I want, but does not work when I …
I'm trying to get the following query both functional and controlled via inner joins rather than this format, as the way it is now will be slow once the db fills up I've never been good with joins and this is the first time for me working with MS SQL …
Hello everyone, I just started working with .net and need to create a simple login page. I have the design page but am struggling with the code behind. This is what I have so far. Alot of it is what I got from samples over the net. Below are the …
How do we go about doing a query under SQL server? And can i actually use the form in access to link to the tables on SQL server? Please advise. Thanks.
Can anybody ttell me the query for the question below, plz? [COLOR=#000000](a) Output the names of students and their addresses for those students who are living in Hunghom. [/COLOR] [COLOR=#000000]thx a lot~~~[/COLOR]
I am trying to delete a specific colum, say ProductID = 30 from table Product_tbl now when I use server behaviour to delete, by filtering the recordset it doesn't really delete that particular ID but it goes only the next one in the row, for example: I enter 30 the …
Hi Everyone, I just wanted to know if it's possible to create a chart in a report based on multiple queries. Thank you for your time
I have been debugging my application for 6 months. Now, when I try to run it I am getting "under the default settings SQL Server does not allow remote connections." My computer is not on a network. I recently went from Visual Studio 2005 Express Edition to the Professional edition. …
Hi, Everybody. I'm new to MS SQL Reporting services, and i've got some troubles with it. I cannot integrate my report with the site. I've tried to do it in such two ways: 1) using ReportViewer control. But the server where report is stored need authentication, and this control doen't …
i have developer a lab system... the lab system include multi test...each test have many sub test user can select which test they want the problem i face know is... after they choose the test n run the test... the table need to store to database i dunno how to …
Hi All, Iam New to ASP and i have a problem. we had an ASP and SQL Server Project in which the login page is the default page. This application has been installed in several computers. Now the problem is I need to develop an application which checks whether the …
hello i want a programming concept in c in which it should take a query of sql and regarding table and then give the output as a resulting instance corresponding to query
Hello Everyone, I just joined this group; I hope I can learn as well as contribute. I joined this group to ask a MS SQL related question, which I already posted. I hope to get lots of responses. -Mike
Hi, I need a view with weeknumbers according to ISO. This means 1-1-2006 is week 53. Now I created a function: [MS SQL] CREATE FUNCTION dbo.WOY ( @Date DATETIME ) RETURNS SMALLINT AS BEGIN DECLARE @WEEK SMALLINT IF DATEPART(dw, CAST('1-1-' + CAST(DATEPART(YYYY, @Date) AS VARCHAR) AS DATETIME)) > 4 IF …
Alright I've written a password manager before in Java, but it sucked pretty bad. I've decided to make another one in C#. My problem is I don't knwo what file format to use. I could use a text file and use des encryption, but I wanted to know if its …
Hi guys I am doing my computer science dissertation on the complexity of navigation within mobile phones. Therefor for this i need to program a menu for a mobile phone which will help reduce time taken to locate functions within the phone. I wish to implement a search facilatated menu …
[COLOR=#000000]Hi Everyone,[/COLOR] [COLOR=#000000] [/COLOR] [COLOR=#000000]I'm stuck in a bit of a problem. I've got a table called sales with a date field in it, but the date is not in the date format, its in the number format and it's too late to change it as the table's got over …
Hi, I am having problem with my Editable GridView. I am selecting columns from SQL-Server 2005 DB using a store procedure [with multiple tables in it] and then I wrote UPDATE and DELTE statements in the GridView query builder. When I run the page, Select and delete works fine but …
Hi, how would i be able to display chinese words by entering Sql? Can anyone please help me? Thanks, Jeremy
Hi Guys,:) I am Sunil, new member to this gr8 group. Wat I want basically is a listview where I can display data of a column (basically a column containing [B]Names[/B]) from an SQL table. Also I have a textbox in the form where a user can type any name …
hi, i have installed sql-server 2000 on win-xp pc . but when i am using sql server it requires authentication from server ,but i do not have any server ,by this i am unable to use sql database in my vb application .is any method to use sqlserver 2000 without …
I am new with SQL Server 2005. Is it possible to store a column ALIAS at time of table creation? User wants business name and cryptic alias.:mrgreen:
Hi everybody, i m qcdms21 , i would like to know can we update in views , i m been told select can be used but not insert. How about update? For ex: i have loanview1 as view , inside it i have loan , guarantor and student db tables. …
I have a question about the possible string match in sql statement, for example I have variable "$val=abc", I can write: [CODE] SELECT * FROM table WHERE field like '%$val%' [/CODE] this will list all recoreds that the field contains sub-string "abc". Now the question is: if I have a …
I have 3 tables that need be joined. (Not necessarily needed info but might help: using Coldfusion with ODBC to Foxpro database) Table 1: Timecard -------- loginname date wrknum time ----------- --------- --------- ------ afrank 7/17/06 1 3 afrank 7/17/06 2 2 afrank 7/17/06 3 3 afrank 5/20/06 1 3 …
Hello, I am trying to implement a fulltext search on a MS SQL database. While I can query each table independently for a specific word, I didn't find a method to query the entire collection of tables for my search key. Is there a way to do this (using the …
How to upload Images to SQL Server database using ASP.NET tools. Also how to retrieve those saved images from SQL Server and display them onto DataGrid. Visit: [URL="http://www.programmingknowledge.com/ImageUpload.aspx"]http://www.programmingknowledge.com/ImageUpload.aspx[/URL]
Hi all, Well I am still new to sql to getting better and better with each query. Now this one has me completley stumped. Here is the query [CODE] SELECT * FROM MOTORS WHERE (CHKCANCEL = '0') AND (DITD IS NULL) AND (CUSTOMERID = '52') OR (CUSTOMERID = '62') OR …
The End.