6,934 Topics
 | |
| | Hello guys! So here's the problem. I'm making kinda simple forum and I'm using SiteMapPath to navigate through sections and threads. Like HOME>>Programming>>SomeThread. But that's not important... Also I have database with 3 tables. One with SectionID and SectionTitle, other one with ThreadTitle and SectionTitle , and the third table … |
| | I've always heard it best to keep processes separate when dealing with Application servers etc. My question is this: [COLOR="Red"]Are there any best practices associated with creating a website that queries a SQL Database? [/COLOR] My thought is to separate the web element from the SQL Server and host it …  |
 | HI all am trying to construct this hybrid of java and mysql. the data comes from a mysql database and I want it to display in the gui. this I have achieved thus far. However I have buttons that sort by surname, first name, ID tag etc....I need event handlers … |
| | Have never worked with either so just at this point trying to get the environment up and running. Yesterday I downloaded: 1. SQL Server 2005 Express Edition with Advanced Services SP2 2. Microsoft SQL Server 2005 Express Edition Toolkit 3.HTML-Kit build 292 did a PHP hello world and was not …  |
| | Hi everybody, I am Hugo . I want to know something more about SQL. please can anybody give me some idea about some basic SQl questions? First of all i want to know, 1.What is the SQL Data Manipulation Language(DML)? 2.What is the SQL Data Defenition Language(DDL)?  |
| | hello, I am designing a web site using ASP.Net over VB , and I need to have user login window, I 've had it from the control and the users specified from the ASP.net configuration but : I wonder if I can bind users from a table containing usernames and … |
| | I want to put together a set of packages to help in unit testing PL/SQL code - does anyone know of any software ( commercial or not ) or books which I could look at for some inspiration. Thanks Nige |
| | Dear members, Please help me in regarding my problem. I am very much confused on whom to blame for the problem........MSSQL? or .NET ? or Win server? I have a dedicated server with 2GB RAM, SQL 2005, 150GB bandwidth, 160 GB disk space etc., I have created a .net application … |
| | hi to all,, some one please help me how to ctreate image table in sqlserver 2000 and displaying image in the datagridview using c# |
| | Hi all, I'm not sure how to phrase this question... I have a table that requires a foreign key of anything table - this foreign key is automatically generated and the key field in the 'foreign' table. So I have the following situation (kind of): Table Observation [INDENT][B]Time_Stamp[/B] - [I]primary … |
| | I've created a sql statement that I'm try get the number of messages that will expire during a certain time period. I'm looking to purge messages according to mm/dd/yyyy. I'm having a world of difficulty figuring the statement format out assistence would be appriciate. SQL script: select originationtime, expirationtime, ((TO_DATE('01/01/1970', … |
| | 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 …  |
| | |
 | 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 not able to update my table.plz do tell me the bug in my code..... when update link is clicked in the first page..the table should get updated [B][COLOR="Green"]page 1[/COLOR][/B] $link=mysql_connect($hostname, $username, $password); mysql_select_db($dbid) or die("unable to connect"); $x = $_GET['name']; $result=mysql_query("SELECT * FROM table1 where name='$x'") or … |
| | hi i have a table which has uname,pss,type fields now i want to check the login (ie is username and password) and if the type is administrator then redirect to a different page... if the type is a user then redirect him to another page... in this apllication there are …  |
| | Below script works perfectly fine from command line, but when I run through browser I am not getting anything inside my $dt. Because of this its always going inside failure scenario. My procedure is going to return either Success / Failed output. Can anybody tell me where I am messing … |
| | I have been working on a program designed to read information from an Access database and display it on the screen. As my main development box doesn't have a copy of Access on it, I copied the data over to a PostgreSQL database and attempted to work from that. Now, …  |
| | 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, I am using MSSQL7 at work along with VB6, and while I have the VB work sorted, I am struggling with the SQL quite badly. Basically, I will try to explain my problem as best as possible, and will go from there. Firstly, here is my SQL statement as … |
| | 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 … |
| | Hi, I have the PHP file as coded below. Is there any way to make directory files open in a new window. I mean, this file shows files in a folder in which it sits in, but how can displayed files be opened in a new window? Cheers Aaron ------------------------------------- … |
| | 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 … |
| | Ive just learnt the basic asp software and linking to DSN etc on a PC. But i use a mac where i work and the previous sites we have, have been made for us by using ASP as we have a windows server. There are people who use asp on … |
 | |
| | hi all, i have a string for example: $str="The annual general meeting is scheduled on ::date:: at ::time::. you all are requested to be present on ::date:: at ::time::." i store it in the Templates_T table in my DB. Template_ID =1 [for eg.] now this format can be used further … |
| | 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  |
| | hi, I have only done basic sql queries and need help on this major one trying to combine many queries into one. What I need is to make the following queries into one: [code]SELECT Username, LastLogin, DateCreated, Views, MainPic, Logged FROM Users WHERE UserID=? SELECT COUNT(AlbumID) FROM ProfileAlbums WHERE UserID=? … |
| | hi, I have only done basic sql queries and need help on this major one trying to combine many queries into one. What I need is to make the following queries into one: [code]SELECT Username, LastLogin, DateCreated, Views, MainPic, Logged FROM Users WHERE UserID=? SELECT COUNT(AlbumID) FROM ProfileAlbums WHERE UserID=? … |
| | :?: Greetings, I am brand new to php and mysql so get out the asprin. smile I am making a php file to pull information from dat files to update my database. When I run http://www.sandpointrealty.com/read2.php I get this error Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result … |
| | Hi, i am using Data Environment to connect VB with my Access Database. Can i use SQL statement in my script (manualy)..?? Please tell me how to do it Thanks RE -Denpasar-  |
 | Hi all, Need to get this thing running. Need to develop in VB6 and hook up the back end to sql server express. VB6 and sql server express are installed locally. Please tell me how to do this to get it up and running. It is urgent. thanks, b |
| | Hi all, I am new here, (as you might have guessed :) After I get the PHP/apache thingy working Or kill myself whichever comes first I will be needed to set up a db back end I would like to pose a question to you learned folks. I notice many …  |
| | Have never worked with either so just at this point trying to get the environment up and running. Yesterday I downloaded: 1. SQL Server 2005 Express Edition with Advanced Services SP2 2. Microsoft SQL Server 2005 Express Edition Toolkit 3.HTML-Kit build 292 did a PHP hello world and was not … |
| | hi i currently making a register page. which include user name, password, retype password, name, nirc, address, contact number and email. can tell mi the code for SQL server and linking? thx for the help |
| | I'm using C# Express and SQL Server Express. I can connect to sample databses I have downloaded to the default location (..\MMSQL.1\MSSQL\DATA) but I cannot connect to a new database I create using SQL Server. The error is "You don't have permission to open this file. Contact the owner or … |
| | Columbus - I am working for a well known insurance company local to the city. This organization offers great facilities, flex hours and has a solid track record for retention. Currently this organization is moving to a paperless system and is in growth mode. They are seeking talented Data Warehouse … |
| | Hi Guys, I have completed a vb6 application that uses sql2000 database. I have sql client installed on my pc. I want to install the application on a machine that does not have sql on it. Will it work or do I need to install sql on the clients machine. … |
| | Here is my code, it works when I leave away the line in bold, I can't figure out what's wrong with my line in bold, I've been checking my database so many times already, can you help me [QUOTE]With gridMieter .Cols = 5 .TextMatrix(0, 0) = "Frist_id" .TextMatrix(0, 1) = …  |
| | Hello, I am trying to set up a string where it taps two databases, Albums and Photos. I need to select the following columns of Albums database and Photos where the Albums.AlbumType='Nightlife' and then order by the sum of photos.views desc for ranking the top 4 (limit 4) This is … |
| | my second thread of the day... hey guys, I was wondering if someone could help me. I am new to SQL Server therefore new to T-SQL, I have worked with SQL before. I am trying to reference foreign keys when creating tables. The code I have in SQL is :- …  |
| | OK.. I want to start trying to develop a web app using an SQL Server 2000 database. The only language I know comfortably (but not totally) is VB (although VB.NET is giving me lots of problems). What should I use to develop this program? Dreamweaver? Visual Studio.NET has web development … |
| | Hi guys! I've never used SQL Server before and I don't want to fall at the first hurdle. SQL Server is installed and connected to the server but how do I go about actually creating the database? I am developing a web based database using dreamweaver and asp.net. Do I … |
| | Dear friends, i have problem in encrypting and storing the password field in my sql server 2005 database. i want to concat my user name and password field and then encrypt and store using md5 in c# using visual stdio 2005 can anyone please help me out...... preethi |
The End.