Search results for query: *

I am having a hard time writing queries after I have normalized my db to the 3nf, before I would place multiple values in a comma seperated list into one column, which made it impossible to work with the data. normailization has helped out tremendously in the application, but now i need to...

I have been working on normalizing a bunch of table that I have. The problem is that now that I have all the data in a bunch of different tables, when I join them on a select I am not getting exactly what I want. example the problem is I took all the actors out of the movie table and moved...

i am trying to fix an access application that was created a long time ago in access 97. After recieving the file I imported it into 2002 and everything seems to work fine. I can't seem to get started though because i can't get passed the forms. When I open the mdb file it takes me straight...

I am trying to build a regular expression that will let me change text between to comments on a webpage. I have a large textarea that users can type in information about a webpage then I want to be able to write that infomation into a template that I have. The start of the text is <!--...

I am using CF5 and oracle 7.3.4 and I am trying to create a query with an IN clause in it. I have done this many times using the same technique but now it is causing me great pain. Here is my code: <cfset session.Event.selTrainerID=ListQualify(session.Event.selTrainerID,&quot;'&quot;)>...

I am trying to write a Coldfusion Application that is sitting on a solaris box running apache. I am trying to figure out is there a way to authenticate to an NT 2000 server. Active Directory is NOT installed, so I can not do an LDAP query. Is there a way using IAS somehow?? I have have read...

I am trying to test whether the enddate is less than the startdate. I am using the date compare function and it is not returning what I expect. Here is the code that I am using: <cfset StartDate=CreateDate (form.selStartDateYear,form.selStartDateMonth,form.selStartDateDay)> <cfset...

I am not very good with javascript but I have kludged some javascript togethter to make a function that works well, but I need to make it more general by being able to pass it the form elements so that I don't have to write ten seperate functions of the same code. I think that there is a way to...

I am having a probelm with what the default session nls_date format is. I am workign on deveolping applications which access my 7.3.4 oracle database. I have an application that deals with lots of dates. The problem is that I develop on a wintel box and our brand new production server is a...

Has anybody had any issues with ColdFusion not showing any error messages?? I have just upgraded to the coldfusion server 5 to devolpe on. I have turned all error messages on in the CFAdmin. I have added my ip to the list to display debuging information. This debugging information shows up on...

I am trying to create a list of variables named Trainer1 Trainer2 Trainer3 Trainer4 etc.... <cfloop index=&quot;i&quot; from=&quot;1&quot; to=&quot;#ListLen(form.selTrainerID)#&quot;> <cfset Trainer#i#=ListGetAt(form.selTrainerID,i)> </cfloop>

I have three tables: tnevent tnagency tnuser ------- -------- ------ eventid agencyid userid agencyid name firstname cotrainer1id lastname cotrainer2id I am trying to search for an event with...

could someone please tell me how to insert the date AND time into oracle. I have tried MANY different ways from examples I have found and NOTHING seems to work. I can't even find a reference to what Oracle wants as a parmameter. Here is what I have at this moment. <cfset...

I have a query: <cfquery name=&quot;qSessionInfo&quot;> select distinct(Location),SessionDate from Session order by SessionDate desc </cfquery> that returns results like this: dec 1,2001 new york dec 1,2001 chicago dec 1,2001 los angles nov 1,2001 new york nov 1,2001 chicago nov...

I am trying to find strings inside lists of other stings. What I have is two tables the first is Sessions with a column LocationID which is a comma delimited list of UUID's the second table is Location with the primary key LocationID. I am trying to create a new table from the old so that...

I have two close to identical sql statements from two different templates. Only of one of them works, but I can't fiqure out why one is getting an &quot;ORA-00933: SQL command not properly ended &quot; error here are two sql statements working: <cfparam name=&quot;form.DISTRIBUTORID&quot...

I have quite a few of checkboxes on a form, and am having trouble rechecking them when I repopulate the form. here is some of the code I am using: <input type=&quot;checkbox&quot; value=&quot;Administrators/Supervisors&quot; name=&quot;TARGET_AUDIENCE&quot; <cfif...

I am trying to popluate an html table with data from a cfquery. The table has a lot of formating and colours. I looked at the <cftable htmltable> but it doesn't have any of the formating that I need i.e. cellspacing cellpading bgcolour etc. Is there a way to keep all of my html fomating? or...

I have a form that submits to an action page that inserts/updates a database table depending on which button was pressed. How can I determine from the form which button was pressed?

I am starting on a new project that involves creating a collection of images, word documents, and video files that would have attached descriptive data. I was curious if I could store the files directly into a oracle database? I am not to familar with oracle and do not know if this can be done...