9,022 Topics
[B]Hi all I am here again ,and this time i returned back and with my hand a problem in SQL server not in asp.net . The problem is the following : [list]I am in a project that contains a table of users[COLOR=Green](user_tbl)[/COLOR] and another table of groups[COLOR=Green](Group_tbl)[/COLOR] . and each …
hey all i need help i am developing web project with ms sql db. i want to know how i can insert a text in db after i changed its font or color or align, i have html editor in one of the web pages, ex: [B]xxxx[/B] the insert statement …
The table I'm searching is varchar. The entries I'm interested in are only numeric. But for some reason there's mixed string/int entries. How can I chose only the numeric values?
I have recently developed a web based database application using microsoft access and dreamweaver. I have used coldfusion to link the database to the html webpage. The website runs successfully at my clients address. However, after transferring all the files to my university web space I receive the following error: …
I've recently become the defacto DBA of two MSSQL databases at work because I am the only one with SQL experience. I have been asked to do some tasks with the databases but this requires and understanding of their structure. I cannot find anything akin to MySQL's mysqldump for mssql …
Hi Guys! I am newbie to MS-SQL Server and I’ve run into a very very serious trouble. My company/organization that I am currently with is running MS-SQL Server 2000 Standard and our problem is: MEMORY Out of my stupidity I upgraded our server’s memory to 4 GIG and to our …
I have a MS SQL DB where I need to add a constraint to a filed of a table. This table is manipulated through an application... in a particular field, the integer (field data type) is subtracted from 5 to 4 or 3 whatever, sometimes a user does an error …
I am developing a system where: - Users can go to a website, sign up for classes, and pay for classes - Or they can come to the store and sign up in person I was wondering if someone could walk me through the steps from the beginning of making …
I have the following fields in table A: GL_ID| Date |GL_Name_VC | Amount |Period_TI|Year_SI =============================================================== 1000|31/12/2005 | Sales | -8,000.00 | 12 | 2005 =============================================================== 1000|06/01/2006 | Sales | -6,000.00 | 01 | 2006 =============================================================== 1000|20/01/2006 | Sales | 2,000.00 | 01 | 2006 =============================================================== 1000|28/01/2006 | Sales | -4,000.00 …
I have the following fields in table A: GL_ID|GL_Name_VC | Amount |Period_TI|Year_SI =================================================== 1000| Inventory| 8,000.00 | 01 | 2005 =================================================== 1000| Inventory| -3,000.00 | 02 | 2005 =================================================== 1000| Inventory| 5,000.00 | 02 | 2005 =================================================== the fields above have the following datatype: Fields | Datatype =================================== GL_ID | …
I have the following fields in table A: GL_ID|GL_Name_VC | Amount |Period_TI|Year_SI =================================================== 1000| Inventory| 8,000.00 | 01 | 2005 =================================================== 1000| Inventory| -3,000.00 | 02 | 2005 =================================================== 1000| Inventory| 5,000.00 | 02 | 2005 =================================================== the fields above have the following datatype: Fields | Datatype =================================== GL_ID | …
I have the following fields in table A: GL_ID|GL_Name_VC| Amount |Period_TI|Year_SI| =================================================== 1000| Sales_HW| -20,000.00 | 01 | 2005 =================================================== 1000| Sales_SW| -10,000.00 | 01 | 2005 =================================================== 1001| Cost_HW | 5,000.00 | 01 | 2005 =================================================== 1001| Cost_SW | 5,000.00 | 01 | 2005 the fields above have the …
I have the following fields in table A: GL_ID|GL_Name_VC| Amount |Period_TI|Year_SI| =================================================== 1000| Software| 2,000.00 | 01 | 2005 =================================================== 1000| Software| 2,000.00 | 01 | 2005 =================================================== 1000| Software| 5,000.00 | 02 | 2005 =================================================== 1000| Software| 5,000.00 | 02 | 2005 ================================================== 1001| Hardware| 10,000.00 | 02 | …
I have the following fields in table A: GL_ID|GL_Name_VC| Amount |Period_TI|Year_SI| =================================================== 1000| Sales | -20,000.00 | 01 | 2005 =================================================== 1000| Sales | -10,000.00 | 02 | 2005 =================================================== 1001| Cost | 5,000.00 | 01 | 2005 =================================================== 1001| Cost | 5,000.00 | 02 | 2005 the fields above …
I have the following fields in table A: GL_ID|GL_Name_VC| Amount |Period_TI|Year_SI =================================================== 1000|liability | -10,000.00 | 08 | 2005 =================================================== 1001| asset | 20,000.00 | 08 | 2005 =================================================== 1000|liability | -9,000.00 | 09 | 2005 the fields above have the following datatype: Fields | Datatype =================================== GL_ID | Integer …
I don't know if this is possible but would appreciate any help. RefDes table: ------------------------------------------ ID RefDes ------------------------------------------ 123 VR1 123 C1 124 C2 123 C2 123 R1 125 R2 ------------------------------------------ Is it possible to write a SELECT statement that will produce the following? ------------------------------------------- ID AllRefDes ------------------------------------------- 123 VR1, …
Hello, i've got two tabels, "Artists" and "Music". The relevant columns are: Artists: [Id],[Name] Music: [Id],[ArtistId], [Title],[Added] I want select the post's in the music table, but instead of returning the artist id, it should return [Name] from the Artist table where Music.ArtistId = Artists.Id (so it looks in the …
Hi! i've been searching for answeres on mssql questions and this looks like a place to find them. hope i can return the favor some day. maybe in perl or something else i know better.
i have a problem on my coding, where it only show me the result of 4 tables instead of 100(for examples)..can someone check the coding flow for me. thank you it is about checking the table and the index size(individually). i tried for days,but still cant get the problem solved.Thank …
i have a problem on my coding, where it only show me the result of 4 tables instead of 100(for examples)..can someone check the coding flow for me. thank you it is about checking the table and the index size(individually). i tried for days,but still cant get the problem solved.Thank …
guys i have problem in saving a report after i put some colors and formats, i am using MS SQL. The attribute is saved but when i want to see it, there is nothing the report attribute contains nothing while the report id contains number. what is the code i …
I have a MS Access db that I use on my local machine to generate numerous reports etc. currently I am manually downloading a copy of the table from the online Microsoft SQL db which contains the data I use in generating these reports etc. I would like to link …
hello, how to close all open sql server connections from vb.net? please help.
Hey, I want a search of name ='Jose' to find both Jose and José, but with SELECT * FROM Users WHERE name LIKE '%Jose%' i only get Jose, in "Inside SQL SQL" an article shows this: If you want a search of name ='Jose' to find both Jose and José, …
hey all i have a database containing many tables, 2 of the tables are same in attributes numbers and names but differs in tables names. one is titled [B]livecases [/B] and other is titled [B]archivecases[/B]. the two tables have a forgien key "typeid" from a table "ctype" to declare type …
Hello, I'm pretty much a newbie with SQL. I have a database that is growing out of control and I'm unable to delete any records (data) from it. I've tried numerous open source applications but nothing has worked. The database is with a hosting and they provide ASP.NET Enterprise Manager. …
:-) Here's another one that's bugging me.....again in VB.NET 2005 and windows forms. After selecting an account from a dropdownlist, I am populating a datagrid with items that correspond to that account. Really, I just wanted to display a summary of the items in the datagrid, and then pass the …
I have tried every avenue I can think of, but this forum seems to be the best to supply help. I am creating a class using NetBeans. I have created the following code, but get an error message for the line "public static Connection getConnection (String strFileName, "","") throws Exception. …
Scenerio. I am extracting Primary key from Listbox to read against the Products Table in Northwind database to populate the textbox controls. This particular column "UnitPrice" is giving me this error message:- " Cast from string "Display" to type "Interger" is not valid". Can someone point me to the right …
I've been working on a production DB on a POS and Inventory System for over a year. That's over a year of data and along the way, I took that system and implemented to 4 locations and 4 individual servers. I've major software updates and Schema changes (adding Views, SP, …
Hi I am trying to delete a name from my database however my code seems to have a problem. It seems to cut out before i actually excutes the SQL statement. Is there something else i have missed in the code. PatientNumber is equal to the value to the text. …
Hello, hello... I've done a little bit of spyware annihilating and whatnot, and I guess I have a fairly clean log now; but seeing as I am not a professional, I cannot be too sure that my log is 100% clean. Anybody care to check it for me please? [CENTER]~~~~~[/CENTER] …
Hi, I am having a table with 16 lakhs records in it. Each record contains approximately 50 columns. I am using MSSQL Database. Basically the table contains details of the user's registration details. I have a application built in VB.net which will be selecting a random user_id and then searches …
hi, im a newbie and im developing a system using ASP.NET programming using visual studio and SQL Server.i was tring to write my first login page, and i connected it to the database, and ran my application.but this error came out,"[B]error while trying to run project:Unable to start debugging on …
Hi. I am working on a particular sql statemtent that looks like this, but I simplified it greatly. [CODE]x="INSERT INTO TableA (T1.Key,T1.Field1,T2.Field1,T2.Field2,T3.Field1,T3.Field2) FROM (T2 RIGHT JOIN T1 on T2.Key = T1.Key) LEFT JOIN T3 ON T1.Key = T3.Key"[/CODE] That is how Access created the statement. All 3 tables have the …
hi im new to this ....but have read a few posts about this trojan.cachecache kit thing. Although this is not my computer i am trying to sort it. A trojan keeps coming up an an autoprotect window .. i take it somehting to do with symantec antivirus .. but when …
Hi all, Has anyone ever tried creating a form in infopath that collects timecard data (hours worked, etc.) then, when the user clicks "Submit", the information gets posted to an SQL database? This is probably fairly easy, but my feeble attempt failed horribly today. If any knows of a link …
Hi all, Has anyone ever tried creating a form in infopath that collects timecard data (hours worked, etc.) then, when the user clicks "Submit", the information gets posted to an SQL database? This is probably fairly easy, but my feeble attempt failed horribly today. If any knows of a link …
Ich transferiere gerade ein Hosting von einem alten auf einen schnelleren Server. Gleichzeitige Versionsänderung MS SQL Server von 6.5 auf 2000. Dabei habe ich mit einer SQL-Abfrage zu kämpfen. Und zwar sieht die folgendermassen aus: SELECT COUNT(*) AS nrecords FROM ABData WHERE (0=0) AND (MARKE='Dodge') AND (Rubrik='Autos') Cold Fusion meldet …
Hi All, I want to save a large string (>8KB) in to a table feild. How can I do this,Pls help me on this
hi if i have table employee with employee_id as a primary key [b]how can i assign the primary key to the columns firstname and lastname?[/b] table structure is something like this : employee_id int not null, firstname varchar(20) not null, lastname varchar(20) not null the problem is that there is …
hey cna you please explain to me the following <" Because the database also stores all the data of the database itself, each database has a number of system tables. Each new database is created following the Model database model. The Master database keeps track of information about the other …
I want a code to upload a ms word file and store it in sql table.I need this very urgently for my project in asp.net(vs 2003) :confused: anybody help me plzzzzzzzzz :confused:
I'm working on a MS-SQL-Server-DB with MS-Access. There are some dozens of forms. I'd like to translate the forms by button-click into another language. I've made a procedure (sub) called by button-click which walks over the complete "Controls" and changes the captions. So far, so good. But this procedure (in …
Hello all! I need to fill a database using microsoft access and sql in an asp page. I need to check that the input is not exsit yet, so I use the following to create sql sentence: tempsql = select * from table where filed= '" tempsql = tempsql & …
my question here is :how do we write sql connections to database that's using windows nt authentication?How's the syntax looks like?tq :confused:
Hello, I have attached a database which will be in use for the question i am about to ask. The question is ... Write queries to retrieve the following sets of information. a) An annual report showing the number of orders and the value of the orders placed by each …
Hello everyone!!! I'm very new to programming in general I'm working with VS 2005 and database built with sqlserver 2005 express. I've built a GUI to add new raw materials into a database Ive Dragged over my conn and adapter generated a dataset. I also am using a DG to …
- Recently Unemployed Proficient Web/CF Developer/.NET Looking for telecommuting opportunities. Proficient with most all databases and equipped to work at home in test environment. - I have developed some sample applications and posted resume for review: - MS SQL 2000/2005, MS Reporting - ColdFusion MX6,6.1,7 - ColdFusion Reporting [URL=http://www.michaelnunnally.com:9050/Resume/]http://www.michaelnunnally.com:9050/Resume/[/URL] If …
Hi all, I'm looking for a nice query tool to query MS SQL and/or Sybase databases. Currently, I'm using Excel to do some minor query stuffs...and I don't mind using it but it get's repetitive when you have to do it for 70 different databases. So I'm looking for something …
The End.