Hello Guys: Below is my code for an insertion into an Access database. When I run this code against Access: I get an error saying "Incorrect Syntax in INSERT...
Hey Andy, The first thing I notice is that if you are using ASP (VBscript) then you concatenate the variables with a "&" rather than a "+". Might be worth a...
hello guys, This is bharanidharank. plz clarify my following doubt, My doubt was in sql query, 1. i have 5 fields in table customerdata i.e Customer_no,...
You really need to give an example of the actual SQL statement that is being submitted to the database engine - we have no idea what it in your various...
Hello All: Would anyone know how I can get the column names for a given database table in a SQL Statement? Thanks, Andy Mills [Non-text portions of this...
Forgot that information. It is SQL. I will also have to do the same thing to verify it on an AS400 database table. ________________________________ From:...
For SQL Server, check out http://www.aspfaq.com/show.asp?id=2177 I guess for the AS/400 you could try something like: SELECT * FROM somemember OPTIMIZE FOR 1...
I do a lot of ASP and query with AS400 tables... I'm not aware of any special query to just get field names, but if you ever need info on making the connection...
Thanks Ray. ________________________________ From: active-server-pages@yahoogroups.com [mailto:active-server-pages@yahoogroups.com] On Behalf Of Ray at home ...
Chris Thanks for your help and offer. I might take you up on the offer on using the Client Access. Thanks Andy ________________________________ From:...
*hi,* * my problem is that when i run aspx file on my server (win2000) so it make error like* " *Description: *An application error occurred on the server....
Hi folks... I need to figure out how to add a cookie, I guess, to allow users to view some material. To date, I've been using SessionVariables, which worked ...
Is there a way to convert this into a delete statement? I am having issues doing so. There are over 4400 duplicates and I would like to do this with one SQL...
Duh...yeah, forgot about that! Thanks! Dian D. Chapman, Technical Consultant Microsoft MVP, MOS Certified, Editor/TechTrax HELP THE ANIMALS...Please Sponsor my...
Do you actually want to do a delete based on these criteria - i.e. delete all the records involved? In that case, you'd put a sub-select in the where clause. ...
I would think that if you somehow converted the item below as a delete, it would delete all entries with duplicates... You would then be without an original. ...
Dave: Thanks for the help. I do actually want to delete all records that have duplicates. This is really just test data, but the live data will not have any...
Chris: Thanks for the help, but I am able to delete all duplicates as I don't need an original. It is "bad test data", but the only data I have to work with....
Here's an article that shows a real easy way to remove duplicate rows: http://www.sqlservercentral.com/columnists/darjun/deletingduplicaterows.\ asp ...
hi friends, i want to set one field as unique constraint in ms access table. how to do. plz help me by bharanidharank ... Relax. Yahoo! Mail virus scanning...
hi, Make sure your directory is setup as an IIS application. In addition, make sure the ASP.NET worker process has been given the appropriate permissions. ...
In its properties, set the indexed property to "Yes (No Duplicates)". ... From: bharani dharan To: active-server-pages@yahoogroups.com Sent: Monday, March 06,...
Hi I am new to ASP.NET. I am trying to create a ASP.NET web application through "New Project" menu. When I click on new project it takes the default location...
I am learning everything about developing websites(starting about 3 weeks ago) by building a web portfolio. One of the pages will be a resume page. I saved a...
If you're just getting a placeholder, chances are that your path to the image is wrong. So check the path that you have set in the link to the image in DW and...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
