Adobe Community : All Content - All Communities

Clearing Session and/or App variables with Log-out Page?

forums_noreply@adobe.com — Sun, 17 Aug 2014 19:21:54 GMT

Greetings

I have 3 distinct user types for my app- admins, appraisers and clients.

All have their own directories and each directory has it's own Application.cfm:

1) <cfapplication name="appraiseri"

applicationtimeout="#CreateTimeSpan(0,2,0,0)#"

clientmanagement="Yes"

sessionmanagement="Yes"

sessiontimeout="#CreateTimeSpan(0,2,0,0)#"

SetClientCookies="Yes">

2) <cfapplication name="appraiserview" ......

3) <cfapplication name="clientview" .......

Each have their own login which simply uses their ID in the DB as the session variable.

login_do.cfm:

1) Appraisers: <CFIF auth_direct_appraiser.RecordCount NEQ 0 >

2) Admins: <cfset Session.user_id =auth_direct.staff_ID> ......

3) Clients: <cfset Session.processor_user_id =auth_direct_processor.processor_ID>

I have had a session persisting for a week now- I have no idea how to get rid of it, and if one simply hits the "login" submit button with no UN or PW, it runs a query on a client (the same one) ?

My logout page is not working at all- if the code were correct, it would clear any session variable? I have not really set an app variable (except timeout) so no need to clear that?

Here is the code:

</CFIF>

</CFLOOP>

</CFLOCK>

alert("You have been logged out from the XXXXX Intranet")

location.href='login.cfm';

</SCRIPT>

Any help would be appreciated- this is leaving a huge security gap in the app right now.

Thanks

Password Protect all .cfm files in a directory?

forums_noreply@adobe.com — Thu, 12 Jun 2014 17:53:02 GMT

Greetings

Can anyone share the code one one put within the application.cfm to password-protect all the files in that directory?

The UN & PW are stored in a DB - of course I could create a session_ID and protect each page individually, which I have been doing for years, but in this case, the pages are being loaded using a half-*ss CMS and the users, other than saving files as .cfm, will not be responsible to leave the code on each page.

In the DB, the user name is subscriber_email, the password is subscriber_password.

Thanks for any help.

Elapsed time in business days?

forums_noreply@adobe.com — Sun, 18 May 2014 21:38:08 GMT

Greetings

I am trying to get query results that would show elapsed time in business days. I have been so far unsuccessful in getting the elapsed days at all.

An appraiser's clock starts ticking when an order is entered in the system (order_create_date). The clock stops for the appraiser when an order is completed (order_complete_date) and the turn-around time to the client is (order_report_sent_date).

I attempted:

SELECT order_ID, order_create_date,

DateDiff("d", order_create_date, order_report_sent_date) AS client_tat

FROM main_orders

WHERE order_ID = #list_orders_all.order_ID#

</cfquery>

SELECT order_ID, order_create_date,

DateDiff("d", order_create_date, order_complete_date) AS appraiser_tat

FROM main_orders

WHERE order_ID = #list_orders_all.order_ID#

</cfquery>

I simply get null results in

#get_appraiser_tat.appraiser_tat# ,

#get_client_tat.client_tat#</cfloop>

Would it be better to <cfset get_appraiser_tat = #DateDiff('d', DateA, DateB)#> etc. or in the SQL statement, and how would one count business days only?

Any help would be greatly appreciated.

Norman

Embed SWF movie with playback skin using FLV?

forums_noreply@adobe.com — Fri, 17 Jan 2014 16:05:23 GMT

Greetings

I have video that needs to be embedded using best practices (javascipt?) and I have only the FLV files to work with. I finally opened the FLV in Flash CS6 after learning that one needs to choose "all files" to even see an FLV (?).

I followed the sequence of how to publish, chose a basic skin, then exported the SWF.

The movie plays fine embeded directly ot using javascript, but with no skin.

Any help would be greatly appreciated.

</object>

</object>

Flexible Criteria Search redux

forums_noreply@adobe.com — Sat, 30 Nov 2013 16:50:08 GMT

This action page to query mutiple drop-down selection only works with 2 choices- when a third is introduced, it ignores it:

SELECT

mo.order_ID,

mo.order_number,

mo.order_property_type_ID,

mo.order_order_type_ID,

mo.order_report_type_ID,

mo.order_client_ID,

mo.order_appraiser_ID,

mo.order_status_ID,

mo.order_rush_status_ID,

mo.order_property_street,

mo.order_property_city,

mo.order_create_date,

ls.order_status_ID,

ls.order_status,

lc.client_ID,

lc.client_company,

la.appraiser_ID,

la.appraiser_fname,

la.appraiser_lname,

lo.order_type_ID,

lo.order_type,

lp.property_type_ID,

lp.property_type,

lr.report_type_ID,

lr.report_type,

lrs.rush_status_ID,

lrs.rush_status

FROM main_orders mo

LEFT JOIN lookup_order_status ls

ON mo.order_status_ID = ls.order_status_ID

LEFT JOIN lookup_clients lc

ON mo.order_client_ID = lc.client_ID

LEFT JOIN lookup_appraisers la

ON mo.order_appraiser_ID = la.appraiser_ID

LEFT JOIN lookup_order_type lo

ON mo.order_order_type_ID = lo.order_type_ID

LEFT JOIN lookup_property_type lp

ON mo.order_property_type_ID = lp.property_type_ID

LEFT JOIN lookup_report_type lr

ON mo.order_report_type_ID = lr.report_type_ID

LEFT JOIN lookup_rush_status lrs

ON mo.order_rush_status_ID = lrs.rush_status_ID

WHERE 1 = 1

AND (order_create_date BETWEEN #CreateODBCDate(FORM.StartDate)# AND #CreateODBCDate(FORM.EndDate)#)</cfif>

AND client_ID = #Form.order_client_ID# </cfif>

AND appraiser_ID = #Form.order_appraiser_ID#</cfif>

AND mo.order_status_ID = #Form.order_status_ID#</cfif>

AND order_rush_status_ID = #Form.order_rush_status_ID#</cfif>

ORDER BY order_create_date DESC

</cfquery>

Thanks to Carl for getting it this far- hair-pulling, hopefully, will stop soon.

Thank you for taking the time to read this.

Norman

Flexible Criteria Search?

forums_noreply@adobe.com — Sun, 17 Nov 2013 20:09:13 GMT

Greetings

I contsructed a form that allows the user to search up to five criteria:

Date range,

appraiser,

order status,

client

priority

I've attempted to set the action page:

SELECT order_ID, order_number, order_client_ID, order_rush_status_ID, main_orders.order_status_ID, order_appraiser_ID, order_create_date, order_property_street, order_property_city, client_ID, client_company, appraiser_ID, appraiser_fname, appraiser_lname, lookup_order_status.order_status_ID, order_status, rush_status_ID, rush_status

FROM main_orders MO, lookup_clients LC, lookup_appraisers LA, lookup_order_status LS, lookup_rush_status LR

WHERE 1 = 1

AND (order_create_date BETWEEN #Session.StartDate# AND #Session.EndDate#)</cfif>

AND client_ID = #Form.order_client_ID# </cfif>

AND appraiser_ID = #Form.order_appraiser_ID#</cfif>

AND MO.order_status_ID = #Form.order_status_ID#

</cfif>

AND rush_status_ID = #Form.order_rush_status_ID#

</cfif>

ORDER BY order_create_date DESC

</cfquery>

The first error encountered is "AND rush_status_ID = #Form.order_rush_status_ID#"

Not yet got this to work- any advice would be greatly appreciated.

Thanks

seasonedweb