Hi folks... My contact at Wiley (publisher) is looking for SQL gurus to help write a training series, as well as tech editors to proof the writing. If you're...
Hi...appreciate any help figuring this one out. It was working before, but now the client moved the SQL data to an Access DB (don't ask!<sigh>) and the IDs...
Thanks much to Daniel who replied to me directly and scolded me for using *...and recommended I specify the needed fields...since some apps might have heart...
As it goes...I got one error fixed...which moved me on to the next.<sigh> Any ideas on this one? Exact error: "Syntax error in JOIN operation." Here's the...
Further...I ripped it apart and the problem appears to be here.. & "FROM csdbo_CLIENT, csdbo_PATIENT INNER JOIN csdbo_OWNER ON " _ It seems to not like the...
I got it working! FINALLY. Just as an FYI...I didn't realize that SQL can work differently in SQL Server and Access...which was why I was going so nuts knowing...
Didn't realise you didn't know. All the engines are different from each other to some extent. Biggest problem I've had with this was trying to develop under...
Thanks for the added info. Yeah, I'd learned about dates, but didn't realize there other major differences. Dev and learn, eh? ;-) Dian ~ View Hurricane Humane...
Hi Group I have a VB.NET utility which has been scheduled to run every 5 mins and check our database for any new data in a specific table and sends the mail ...
Yes, you can convert it to a service. ... From: active-server-pages@yahoogroups.com [mailto:active-server-pages@yahoogroups.com] On Behalf Of Ilyas Sent: 10...
Although, IIRC you'll have to write a separate app to monitor the service as a service shouldn't have a GUI. Dan ... From: active-server-pages@yahoogroups.com ...
the main functionality would be listing/monitoring the db processing. may be, i can drop windows service and write a utility which calls the sub repeatedly...
Hi folks, Suppose i have variables Zone_z1, Zone_z2, Zone_z3 etc upto Zone_z8. I want to assign Zone_z1 to 0 or 1 based on the data retrieved from the...
A variable name is just a name. It isn't a text string, with or without the &. There are several things you can do: - Use an array. The actual zone number...
To make a long story short, I'm upsizing a database from Access to MS SQL Server. Major difference in code seems to be the 1 vs -1 for true and I can cope...
Christine: If you go into the Design of the table in Enterprise Manager: you can set the default date to GETDATE() by entering this into the Default Value...
Hii This script is working.But, when click the delete link, I got error message "File note found". Can you help me please? Ozzy. ... <body> <% process =...
I have a script where a subroutine builds my tables and fills them with DB data. Is it possible to make a calculation and pass it to a root variable from the...
You can reference / change a global variable from any sub or function within the same page or an included page. However personally I'd change the sub to a...
Can't change this sub to func for way too many reasons. I have read about Global, Session and Application variables but I still dont know how to call a Global...
You can't really have global functions or subs, just global variables; To keep an amount for each user in the session_onStart event have Session("Amount") = 0 ...
I have been with hostcentric for the past 6 years I have many web sites there -they were just bought out and no longer support the components that I use...
Adina: I used to use M6.Net, but I would NEVER recommend them and would encourage everyone to never use them. I have switched due to their poor service and...
I need to load data from an excel spreadsheet into SQL Server using Visual Basic .NET. Currently, I am retrieving the contents on an excel spreadsheet(around...
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.
