Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MS SQL Server
 Will this work in other db's		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

DavidRhodes
Senior Member

United Kingdom
1222 Posts
Posted - 15 April 2004 :  17:47:07  Show Profile
Will the following statement work in Access, MySql?
UPDATE " & strTablePrefix & "ADS_CATEGORY 
SET AD_COUNT = (SELECT COUNT(ID) 
FROM " & strTablePrefix & "ADS_CONTENT 
WHERE TOPIC_ID = " & strTablePrefix & "ADS_CATEGORY.ID)
The UK MkIVs Forum
Edited by - DavidRhodes on 15 April 2004 17:47:42

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 15 April 2004 :  18:06:05  Show Profile  Send ruirib a Yahoo! Message
It won't work in Access. Don't know about MySQL.

http://forum.snitz.com/forum/topic.asp?TOPIC_ID=52432

Snitz 3.4 Readme | Like the support? Support Snitz too
Edited by - ruirib on 15 April 2004 18:07:08
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.22 seconds. Powered By: Snitz Forums 2000 Version 3.4.07