9,022 Topics
Hi , Hey I have a small problem.... For a certain field in database, tha values are sent from front end(JSP page) . Each individual value must be extracted and then inserted into the database..... Before inserting, we have called a procedure which will extract each value and insert.... Moreover …
Hi guys! I was wondering if comeone could help me with transferring data from one table to another. I am storing information of all customers who make an enquiry (PotentialCustomers) then transfering their details into a Customers table if they decide to purchase something from the company. How would I …
I would like to know how to apply Constraints after creating a table. I was just practicing and creating a database HomeInventory by reading the free e-book from Microsoft. But I'm trying to implement the functions using T-SQL. So How can I do so? [code] CREATE DATABASE HomeInventory USE HomeInventory …
We have a SQL server on a DL380 with 8GB of RAM and 2 processors. This should be enough to host a couple of databases. When I'm on the same LAN as the server (on the outside of the firewall) a select * from [tablename] returning 12000 records takes less …
hi am raj! am a asp , sql server 2000 programmer i need a sql query to select unique rows based on noofcards,versionno,id here am giving the database ------------------------------------------- id email ccno vno nc ------------------------------------------- 41 [email]b@r.com[/email] f 2465 1 1 41 [email]b@r.com[/email] f 9898 1 3 41 [email]b@r.com[/email] a …
Hi, I need to Store a PDF File into an SQL DB and read it back from SQL is it possible please help me. I want to use VB.Net Thanks a Lot
Has anyone installed it? I've downloaded both express and full developer edition but I can't get past the user account stage. Can someone give me valid userID's and passowords for it? I don't have a password on my user account though..
I am working for a software company as a senior programmer and I currently is charge with designing large .NET project involving WinForms development (C#. WinForms, SQL Server). With this increased responsibility I was just wondering if there is any code generator which would give us the freedom to focus …
Hi I am using 2 dropdownlists such that corresponding to the item selected in the 1st dropdownlist only the related items will appear in the 2nd dropdownlist. The problem is that the 2nd dropdownlist is never populated. My code is: Sub popdropdownlist1() Dim myConnection1 As New SqlConnection(ConfigurationSettings.AppSettings("connectionString1")) Const strSQLC As …
hello there... i need help with cross tab query with sum(case actually iam using ms access 2007 and vb.net 2005 i have problems with the sintaxis ill paste the code below: TRANSFORM SUM(cantidad*(case tipo WHEN 'Entrada' else 1 then 1 end 0)-cantidad(case tipo WHEN 'Salida' else 1 then 0 end)) …
hi there , I need to know if an ASP.net project written with VB can send data to excel sheet and perform specific mathematical operations (but simple)and then save it in SQL database created using SQL provided by the.Net environment ? your help is appreciated I really need to know …
I'm a bit of a beginning to PHP, so I hope that this question isn't too terribly simple. I'm trying to write a flexible query that will use data from an HTML form to create a SELECT statement for a MSSQL database. I've tried writing a sample query, but I …
I'm working on several scripts that form a small, custom build appointment scheduling application. I'm having some trouble with a function that I'm using to check whether appointments for individual times during a given day exist in the database. The function: 1) creates a table 2) uses the date function …
Hello, First I apologise if this isn't the right forum... I have a vbscript that is non-asp. It is run in a program called EFI-Logic that is an ERP. EFI-Logic caonnects to our MSSQL database for normal operation. The problem is that on some computers I get the following error: …
Hi, I have created a Crystal Report Viewer. When compiled on my machine it works fine. However, earlier this week I had to make a copy onto a server. When doing this I had encountered several problems that I maanged to solve...except for one :o(. No matter what I try …
when a user logs in i want assign a particular form to him depending on the user name he entered. that means different forms for different users.im using oledbdataadapter to connect to sql. i will appreciate your help.thanks
Hello, I need to develop an executable file suing vb.net, that will take in an article number as a parameter. Then using this article number a search will be performed in a server directory folder for a file that (if exists) will be named by convention article_number.file_extension the article number …
Hi All Where to start ? Well, been developing apps in VB6/VBA for more years than I can remember, would concider myself fairly advanced with VB6 and Access/VBA. Also pretty hot with SQL Server and T/SQL. Experienced in developing multi-tier apps using class modules to abstract interface/business/data layers. Have developed …
hi, urgent help needed i need to know all the data types in SQL database each one used for what ? when is the best use ? and so on which are fixed length and which are variable length .. ex: nchar(n) : is a ....... [B]specifically[/B] what data type …
Hi, I am on my work placement where I have been given the job of developing the company's web based database. I am very confused as in university I have only learnt the basics and the company are expecting a lot more of me so I have been trying to …
Hi All I'm having a spot of bother trying to retrieve and display SQL Server 2005 IMAGE data in standard picture box controls. I am converting an Access 2003 application that uses bound forms and all works fine. I have been kicking ideas around for a couple of days now, …
I am trying to design an SQL statement that will delete the MIN value(s) in one field. I have three fields of interest: Table: SUM Fields: Parcel, Soil_Texture, Area Ex. Parcel #1 is duplicated three times b/c there are three Soil Ttextures and three Areas associated with it: i.e. Parcel …
Hy Ms/Sir, I am new in VB.NET. I have developed different applications in VB.6 and now i want to create dynamic report in VB.NET 2003 using Crystal Report. (i want to pass a sql query from any form and want to see its result in report format) If any one …
Hi every one, I am Working On SSRS, In Reports I am Showing One Column As A Paragraph , Eg: ApplicationSIPNTCCBApproved, May 8 2007 7:05AM ApplicationICCBApproved, Feb 12 2007 1:42PM ApplicationAITApproved, Nov 6 2006 7:24AM ApplicationCRSubmitted, Oct 14 2006 8:42A I need To show It in new Break line ApplicationSIPNTCCBApproved, …
can any one please help create a sql script that searches based on atleast 10 conditions with where ... and clause $query_rsearch = "SELECT id, job, description, location, cname, ctype, sal, exp, industry, postd FROM jobs WHERE job like'%$k%' and location like '%$l%' and ctype like '%$i%' when i use …
I am using VB 2005 Express Edition. I have adatagrid that cloumns bound to 3 different sql database tables. There are 2 columns that I want to link to each other. The one is a Client column and the other a clientid column. Both these columns are bound to a …
Can please anyone help me on how to develop an Auto Searching System just like in Google and Yahoo.. im using VB.NET as front end and SQL server 2000 as its back end.. this is my code but it doesnt work... [B] SqlCommand1.CommandText = "SELECT eol_id, firstname FROM eol_info where …
Hello every1, I need some help 4 my project. I have listview having names as listviewitems which r already sorted. Now if i type any alphabet say H in textbox then i want focus on the name wchich starts from h in listview. I m working on vb.net 2003 and …
HI all i want to use the apache torque tool to connect to the ms sql server 2000.As i am a beginner can any one advise me from where to start to understand the working.Any pointers in internet or any books will be appreciated. Thanks Umadas
Hello every body... I'm a university student and have got a senior project by asp.net. Actually I'm looking for a help.One of the forms I have to insert photos into sqlserver but i don't know how to do it. Can it be done by gridview???? . . In addition, I …
I have made a report in Crystal Report, fetching records by SQL Query from ODBC Datasource. The query is taking too much time and error is comming after 50 seconds that timeout expired. What would be the problem ??
We've got a database with a table that is growing fast. The database is a SQL db that exists at another location connected via the Internet. Originally, we had code to edit records, one at a time by flipping record by record (one record displayed on the form). Unfortunately, this …
[COLOR="Green"][B][I] I've got a SQL server that uses an external HDD to do backup/transaction logs. The drive specifically has to be the "I" drive in order for the scripts to run. All was working fine untill I replaced the 5 external drives with new ones. Same size, same brand, different …
i am using tomcat 5.0.28 in windows. i tested some html ,servlet, jsp in it and it executed properly. but when i used a servlet which required database connectivity it is generating error. i am using sql server 2005 as my database. plz. tell me how can i configure my …
I m working on a VB project with MS SQL SERVER 2000 as backend database and Crystal Report 8 for Reports. The problem is : When showing a report, after some moments error comes as Microsoft OLE DB Provider for ODBC Drivers: [Microsoft][ODBC SQL Server Driver]Timeout expired When I click …
I'm having trouble with the following scenario: drivers may have any of the 16 types of certificates, tasks may require any of the 16 types as well. What I need to do is build a query that will selectd all the tasks a certain driver can perform. Example: driver has …
sorry...By mistake
Hello All.. I am a new Member in this forum, and Iam new user to SQL Server Express. I need to make instal to my project . my project C# with DB sql server express my Question is: How to make instal the sql server express with my project to …
Hi, I have a text file that needs to be exported to a sql server table. the text file is something similar to this, ------------- 01.08.2007 06:00 go to work 12:00 lunch 17:00 go home 19:00 dinner 21:00 go to bed 09:00 go to leisure centre -------------- I need to …
Hello, I'm working with SQL server 2005 and a database that has "equipment status" data that is spread across several tables and is time stamped in only one table, there are multiple instances of duplicate records with differing time stamps. I need to select only the newest time stamped messages …
hi...c#.net i'declared 2 major columns as primary key...though i m able to insert duplicate entry... i'm using vs-2003 and sql-client object to do so.... i've taken support of mcad-book.....
Hello, need help here. i did come up with something but i get confused. please help me out so that i can proof-read my solution. Thanks Malcolm A company called Street Order Ltd manages street parking in Kampala city. The company collects revenue by charging any vehicle that park on …
hi, i am using vs.net 2003 and mssql 2000. currently my db size is 2.5gb including DB transaction Log File. For (.BAK extension) is 1.55 gb. May i know how to expand or improve my DB because when it reach the size (2.5GB). i will always get error message : …
Hello, I have heard a lot about SQL Injection. I was wondering how does an injector come to know about the table/column name when they cannot see the asp codes in a website? Can someone explain plz? Thanx
We have an Access database that another department is taking over and considering switching over to FileMaker and using on our website (which we manage) with Sequel but - we have heard there are problems with using FileMaker with Sequel....does anyone know if this is true? and if so what …
Is it somehow possible to retrieve a string and then convert it into a mathematical expression? for example i have this string '14200 * 5' and then i want to convert this into a mathematical formula so that i could get the result of it which is 71000.. .. i …
Hello, I have a quick question. I'm currently using MS SQL 2005. I have a main table which has many fields. I created a view#1 which imports all the rows from the main table but I only select the "City" field, "PurchaseDescription" field and a "Cost" field. Only the city …
Hi guys, I have two tables one for that holds Customers details and one that holds Potential Customers details. The Potential Customer table is needed so the company can see who has enquired about the products but not bought them. I need to be able to automatically transfer details from …
Hi Guys, I need some help. My application reads an excel file and dumps it into a recordset. The problem is that if a coloumn in excel has numbers and text in it only the numbers are dumped into the recordset and not the text values. The text values are …
Hi! I'm a bit of a beginner at PHP, and I'm having trouble comparing two strings in a conditional statement. Both of the variables are strings, but one of them them is assigned from a MSSQL database. In this database, it of the unicode varchar data type. It doesn't seem …
The End.