• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

Multiple INSERTS into database from one call of a CFC Function

New Here ,
Oct 12, 2006 Oct 12, 2006

Copy link to clipboard

Copied

I have a CFC that logs page visits on my websites. This logging works great on all my web pages except for the 2 that use SES URLs. on those pages I get multiple INSERTS into the database.

I have test that the CFC is only getting called once, that there are no includes calling the CFC from anywhere else etc.

I'm running Windows Server 2003 Standard, CF 6.1, SQL Server

I would like to know how ColdFusion handles page requests. For example...

www.example.com/myfile.cfm/a_ses_url/what_we_be_data

IIS somehow knows to send this request to ColdFusion... what does ColdFusion get from IIS?

we have code on the file.cfm page that parses the url into chucks so we can use it
but before that happens does coldfusion think it's seeing multiple directories? in other words is it calling th Application.cfm file multiple times before it knows that it's a SES URL???

Please Help :P

Thanks
TOPICS
Advanced techniques

Views

240

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Oct 13, 2006 Oct 13, 2006

Copy link to clipboard

Copied

I have never seen information passed to a CF page using a "/". I always
thought you send variables via ".cfm?*=*".


Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Oct 13, 2006 Oct 13, 2006

Copy link to clipboard

Copied

LATEST
In regards to the subject of this post. Do you want multiple inserts into
one database through a CFC (looping inserts) or inserting into multiple
databases with one call to a CFC?


Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources
Documentation