9,022 Topics
I have MSDE installed. what do i need to create a blank database with the fields required? I have been using an Access Db, should the operation of a MSDE database be similar except with more abilities?
Please tell me the difference between the two thankz
hi I will be thankful if someone tells me from where I can download a free erp project develpoed in asp.net/sql2000. thanks in advance.
Hello, Can anyone explain to me how I can create a function that I can use in SQL. Thanks
Is there a way to get the current value in the process of a select statement? Such as [CODE] SELECT pk_ID, columnN and be able to evaluate what pk_ID is at this point WHERE This = That [/CODE]
How to set or unset IDENTITY Property of a column through code or stored procedure for Sql Server 2000. We are adding some data into a table and then wish to set the Indentity property thr' code or stored procedure. Any help appreciated. Regards [Sham]
ok its one of those things i can't get my head around it at all.. i dont know if it the code i have already thats causing the problem or the fact that i dont know how to do MOD properly.. :( its causing bad gray hair.. :( so if …
hello... any one have any idea about sql injuction....how i can retrieve database from any site.. Raza. [email]hasnainr1@yahoo.co.uk[/email]
I change query parameters in my code. i want the query to change her Sql property to new sql with new parameters. Set QueryDef = CurrentDb.QueryDefs("q_QueryName") QueryDef.Parameters("[Param_1]") = stringvalue_1 QueryDef.Parameters("[Param_2]") = stringvalue_2 QueryDef.Parameters("[Param_3]") = stringvalue_3 QueryDef.Parameters("[Param_4]") = "#" & Format(timevalue_1, "HH:mm") & "#" QueryDef.Parameters("[Param_5]") = "#" & Format(timevalue_1, "HH:mm") & …
Hello, I am attempting to make a stored procedure call to an ADO. I will paste in the try loop. Problem is code compiles and runs, however; the stored procedure never runs. It's supposed to create a row in the DB, and the row is never created. If I run …
hello i just joined the forum. i like computers and i think i would be of some use as a tech but mostly i like programming i'm a real amateur at it but iw ill stop at nothing to learn all i can learn. i like trying new things because …
Hi All I am facing problem is SQL Server 2000, with OPENXML. I am having data which i receive from some other database in form of xml doc. Now I have to use this xml data as JOIN with MS SQL 2000 database table. But as everybody aware that using …
Hello all, im writing a c++ program to interact with an SQLServer database. my code will run a query and retrieve data fine. for example SELECT data FROM TestTable returns all strings from the data column. but when i run the following statement INSERT INTO TestTable (data) VALUES ('HELP') i …
Hi All, First post and would appreciate any help. I want to start a forum at work. The IT department have quoted an unreal price. Can someone please tell me in idiot terms what I would need and an approximate cost to get it running. For instance, I understand it …
I am ready to start using MSDE. When I run the setup for MSDE it tells me I need to set the password. I have read the "help" on the MS web site but it is still not clear to me how I setup the password or anything else so …
Hi, I am very very new to ASP. So far i have been able to connect to the SQL database using dreamweaver mx 2004 but im not sure where to go from here. I have a support databse that i have setup with a few records. The table structure looks …
[size=4]Sams Teach Yourself Active Server Pages in 24 Hours[/size] [b]by Christoph Wille, Christian Koller[/b] Worth it for its price, but prepare to work - If you buy this book, then be prepared to work. If you're new to the whole programming field, or maybe just web programming, don't think the …
Hi, I have an ASP.NET page that contains quite a few looping SQL queries. After either loading this page (all.aspx) or doing a few table sorts the page freezes up and just loads for about 20 seconds. Sometimes the page just loads and doesn't show any results when I know …
Hi All, Can someone please help me with this...I have a search page which searches for users on the database. I need to get the username first and last names and write them to another page. I am not sure how to do this. an someone please help....so far I …
how i can connect sql server database to asp please send me script.or give me tutorial.
Hi, Can someone show me how I would use the multi-threading instead of a case statement for parsing out a file? I have a file that is currently being parsed in C#. Creating Primary keys and foreign keys and putting the data in several dat files. Then I use dts …
So... what is better, SQL, MYSQL, MSQL, POSTRESQL, and etc for a fast database that must be used in conjunction with asp and php. For now, i'm looking for the easiest database to be used in conjunction with ASP. Any suggestions? [flash]http://www.geocities.com/cyberpitstop/footer.swf[/flash]
pls, any one can send the doc. which can help me to write ansi sql queries which are equalent to my existing ms access quiries. senario: i have program developed in VB6.0 AND MS ACCESS. now i want to support my program MS ACCESS as well as SQL SERVER. IS …
I'm doing final yr project that I would like some input and opinion whether mine thinking is workable. I am intend to design an application that help to ease web designer work on designing a dynamic web page that required frequent update of information. e.g. newsletter. Current practice is using …
Hi all, I want to make a report that the column headers are getting from one of the field in the dataset. Example, dataset ds has table A with 4 columns, col1, col2, col3, col4 I would like to use col1 values to be the column headers of the report, …
Anyone know how I can get sql results from three cfselect forms. I'm trying to have the user select from three cfselect lists and draw results based on those choices. I'd appreciate any help you can give. Thanks
Hi, I am working on a project using Java and embedded SQL in the Java. I have gotten the SQL to successful do what I need it to (In this case, create tables and insert data into them). However, I am having a difficult time with IO. The goal is …
Here is my log: I think! Ads 234 is absolutely driving me insane. Please help! Logfile of HijackThis v1.98.2 Scan saved at 1:47:53 PM, on 11/15/2004 Platform: Windows 2000 SP4 (WinNT 5.00.2195) MSIE: Internet Explorer v6.00 SP1 (6.00.2800.1106) Running processes: C:\WINNT\System32\smss.exe C:\WINNT\SYSTEM32\winlogon.exe C:\WINNT\system32\services.exe C:\WINNT\system32\lsass.exe C:\WINNT\system32\svchost.exe C:\WINNT\system32\spoolsv.exe C:\Program Files\Netropa\Multimedia Keyboard\nhksrv.exe C:\Program …
Our first real production experience with Source Control came a year ago when we started to cooperate in software development with two other outsourcing companies – one of them is located in Europe. Since Visual SourceSafe and similar tools at the time could be used only in the intranet environment, …
Our first real production experience with Source Control came a year ago when we started to cooperate in software development with two other outsourcing companies – one of them is located in Europe. Since Visual SourceSafe and similar tools at the time could be used only in the intranet environment, …
Hi just started this new jsp course stuck in this so if you guys can please help would be very happy.The problem is this i am trying to make a jsp that asks for a username and a password and the thing is i am trying to put these datas …
I am having problems making my code access the primary key, and to print information out to screen in a C++ program that I Am writing. Need some help PLEASE ! The Primary Key Name is ID1. HERE IS THE CODE #include <windows.h> #include <stdio.h> #include <conio.h> #include <iostream.h> #include …
Hi, i'm trying to make use of sqldataconnections/commands&readers to populate a datagrid..the msdn collection lib. hasnt been much help at all in this regard :sad: In addition to binding to the datagrid, i also want to be able to make use of the datagrids ability to update the data to …
I'm ujsing php 4.0.3 with apache web server. generally i use mysql. but i have to use mssql for another reason. so i am using ODBC for this purpose. but the "odbc_fetch_array()" is not work. says, undefined function. but as far i know, this function should work with this version …
NEED some one to help me Access a Primary Key in SQL for MS, with the primary Key Being ST with a AutoNumbering of 23, HOW can I :cry: ? SEE code from YESTERDAY Chester1 at 09-28-2004-05:02pm.Thanks for the help!
Need HELP! This Program that accesses a data base will not print out information from Data Base.I think the Problem is in the SELECT statement.The Primary Key is ID1, I want to Access Primary Key 2, Field Father but when I run it, it will only print out Quote: " …
I need to learn SQL to access MS Access what book is the best to get :?:
Hi ! I am getting this error 2 times a week . monitoring paged pool and handles etc.. only showed that services.exe and cqmghost taking anourmous amout of handles error starting when handles amount around 5 000 000 - 6 000 000 Windows 2000 sp4 , SQl 2000 sp3 Also …
I have succesfully set up a Connection and a System DSN and conected to an SQL Server database. I have succesfully created a statement returning RecordSet and executed it. The problem is that when I try and get the data from it, it appears to be empty and gives me …
hey guys, i dont know if this is the right forum for SQL errors but i need some help on the following error: Connection failed: SQL state: '28000' SQL Server Error:18452 [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. ok, …
Hello! I am wracking my brain, trying to figure out how to return & display a column's description. I work in Cold Fusion with SQL 2000 database. My table name is "clients" and the column in question is "client_firstname" The description of this column, as entered in Ent. Mgr, is …
the program works fine but it gives this java uses or overrides a deprecated API error after i compile the code is below it is a program that uses sql the data base is northwind.I hope you could help me its a project so any help would be welcomed. [CODE] …
Hey all, I have a table with a primary key in it. I use stored procedures to insert new records. What I want to know is how do I make it so a column (foreign key) in another table adds the same number as the primary key in the original …
I've at least *seen* PHP code before, and have modified my own phpBB forum moderately. However, I've been set a project to build a web interface for recording skittles scores (like 10-pin bowling, but with 9 pins!!), and producing a nice ordered table with player names, number of games played, …
Ok guys, check this out [code] select app_given, app_surname, contract.contractID from contract, progression where pay_nop like 'PAY' and contract.status like 'Active' and app_type like 'Apprenticeship' and Contract.ContractID = progression.contractid group by contract.contractid, app_given, app_surname [/code] Ok, this works FINE. But, when I try to add Not..: [code]Not Contract.ContractID = progression.contractid[/code] …
I have the following page that I created in Dreamweaver 2004 MX, but don't know how to get some form inputs working. So, I have hardcoded them for now. You can see them below right afte the where clause. Can someone please help me create just a simple form that …
I have a table. I will add thousands of records to this database each year. It’s essentially needed to maintain inspection records. Each problem found get it’s own record. Its possible to go into a building and come out with 20 or more problems (20 new records). Records older than …
Well basically for the assignment I have to write a project that reads data from a .mdb database file and stores this data into a 2D array, then lets the user manipulate the data in the array (stuff like adding, editing, sorting, deleting and searching data) by using GUI and …
Hi all, I have been working in software development field for the last 13 years, most of my projects were done FoxPro, Visual foxpro, SQL server database backend and some of the small projects in VB(not good VB programmer). all my applications are desktop, client server applications. now I wanted …
I have been unable to get rid of bookmarker.gen I am not sure what to do and look to you true wizards for help. Below is my log from hijackthis, any help out there? Thanks in Advance :rolleyes: Logfile of HijackThis v1.98.2 Scan saved at 8:33:45 PM, on 8/19/2004 Platform: …
The End.