Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by GunJack
-
Automatically updating status
It depends on the database your using. I'm not a database admin but I believe what you are looking for is called a "trigger". If I remember correctly, a trigger is code that is executed when a particular event happens. You could probably write a trigger to update the status when... -
Retrieving record ID after insert
Thanks for the info, that's what I needed. I didn't realize you could work with the recordset object like that but that'll do what I needed. It's now working so thanks a bunch! GJ- GunJack
- Post #6
- Forum: Microsoft: ASP (Active Server Pages)
-
Retrieving record ID after insert
Unfortunately stored procs are not an option. I was hoping for a way to serialize the code execution and thought there would be a similar type of locking mechanism available in ASP as in CF. Thanks GJ- GunJack
- Post #3
- Forum: Microsoft: ASP (Active Server Pages)
-
Are random queries bad?
It sounds like a performance issue with either your host's server or possibly with MySql. From what I've read, MySql is a good database but still has limitations and is not quite ready for real production environments. If the host's server is an adequate machine, you may just be dealing with... -
Retrieving record ID after insert
I need to insert a record and then retrieve the value of the autonumber field associated with the record. I can easily do this with an insert followed by a select max(id) from table1 (where id is an autonumber field). What I'm looking for is how to ensure that two inserts at the same time...- GunJack
- Thread
- Replies: 5
- Forum: Microsoft: ASP (Active Server Pages)
-
ascii chars
Hey Sylvano, I think Notepad is getting confused about the extra chr(10) and possibly removing the entire sequence. On windoze, a crlf is designation by #chr(13)##chr(10)# so if you want two crlf sequences, use #chr(13)##chr(10)##chr(13)##chr(10)# instead of #chr(13)##chr(10)##chr(10)#. I... -
CFIF statement help
Just change the <cfif> statements like this. <cfif listfind(#query1.codes#,"1")> x </cfif> <cfif listfind(#query1.codes#,"2")> z </cfif> <cfif listfind(#query1.codes#,"3")>... -
CFIF statement help
I think this will do what you want: <cfif listfind(#query1.codes#,"1")> x <cfelseif listfind(#query1.codes#,"2")> z ...... .... </cfif> Hope this helps, GJ -
delete row from the query
I'm not aware of any function to remove rows. If you really needed to delete rows on the CF side, you could always create a new query and add only the rows you wanted to keep with queryAddRow(). Not a great solution but it should work. GJ -
Show files in directory based on permission level of user.
Hey DeZiner, Would something like this do what you want? <cfdirectory name="fileList" ....> <cfquery name="Perms"> select files from fileTable where access_level = .... <cfoutput query="fileList"> <cfif... -
CFLocation Tag Attributes
One other option is to check the script name and load the login as long as it's not the other page. <cfif cgi.script_name neq "/navbar.cfm"> <cflocation url="login.cfm"> </cfif> You could also pass a url variable to pages that shouldn't redirect to the login and check... -
Creating new pages from template
Hey Niclas, That line is how you would specify which course out of all the ones in your database you want to retrieve and display. The variable #url.courseID# is a URL variable and is passed to the template via the url like this: http://domain.com/templatePage.cfm?courseID=73 In this... -
Creating new pages from template
Hi Niclas, If you want to have each course with it's own webpage but sharing a common template, I would store the course info in a database and have the template pull the specific course info and display it. If I understand your question, I think this will do what you want. <cfquery... -
CF returning extra HTML
Hey Duncan, My guess is that you have an application.cfm somewhere that's inserting the unwanted code or either your webserver is somehow configured to add it. I would put an application.cfm file in the same directory as your script with just a single line <cfset x=0> If this solves the... -
spaces in a field name
Hey King, Here's some additional info that may help. <cfquery name="q1" datasource="myDS"> select "field one" from main </cfquery> <cfoutput query="q1">#q1["field one"][currentrow]#<p></cfoutput> Hope this helps, GJ
