So I first tried to solve the problem below using Stored Procedures, but then I thought, why not try Triggers.
Table 1 has a field called id1. It is the primary key and is an auto-generated incrementing in an ascending order by 1.
Table 2 has a primary key called id2. The primary
key is...
This stored procedure does the following. Table 1 has a field caled id1. It is the primary key and is an autogenerated incremeneting in an ascending order by 1.
Table 2 has a primary key called id2. The primary key is an autogenerated number incremeneting in an ascending order by 1. It has a...
I have a form which submits to a SQL Server 2000 database.
I have a registration form for a single user which adds data to three separate tables. I need to insure that when the data commits and writes a new row to the first table and adds a new unique primary id, the second and third table...
Hi Guys,
I need some help creating an input mask for a date entry field. I would like the user to have the delimeters automatically pop up as they type in a date, or even have the delimeters pre-populated.
Listed below is the input which I would like to apply the input mask. I am pretty sure...
Hi Folks,
I have been trying to get php to play nice with apache 2. No luck so far,
Added these lines to the conf file in apache:
1) LoadModule php4_module /php/sapi/php4apache2.dll
(also tried LoadModule php4_module /php/sapi/php4apache.dll)
2) AddType application/x-httpd-php .php .phtml...
I am a bit of a novice at SQL Server 7.0, and my attempts to write a cascade trigger that actually works have been fruitless.
I need to insert a new record with the identical value in MyTable2 every time a new unique id is generated in MyTable1 for column customer. For e.g. unique id with...
Anyone know why my <TITLE> tag is not functioning?
I have spent WAY to long trying to figure out this idiotic problem. Whatever I have tried has failed. the title tag is not that bloody complicated, but my title just does not seem to show up,Thanks guys and gals for your input
<HTML>
<HEAD>...
Arggh, Still not working.
Is this a limitation of Cold Fusion validation(or my programming skills)? I have been trying for some time to use an JS onfocus call from a cfinput tag
In the cfinput, if a user does not enter a surname, a message will pop up telling the user to enter a valid surname...
I have an index page and that page has a hyperlink to another page. If a user click on that link is there any way to pass a variable I set on that first page to the linked page. The point of this is that I have forms that can be entered on the internet by customers and forms entered by...
My application works fine on my development machine: Windows 98 using PWS4 with a Visual Foxpro 5 backend database.
The forms and associated processing pages updated/inserted/deleted with no issues.
When i moved my CF files and database to a hosted service and tried to submit a form page I...
There are two parts to my question:
I have a form that allows for multiple image uploads.
What I want to do is to be able to insert the path of the image to a field in my database.
Right now I can upload the actual image to a particular designated place on my server.
I need to know where...
I have created a Form that allows for the user to upload 4 files to a designated place on my server.
The user can also go to an update form. This forms contains pre-filled data they entered on the original form. Can I use cffile to locate and replace the original file that was uploaded...
I have a checkbox input value.
<CFFORM ACTION ="individual_minicab_registration_processing.cfm" METHOD="POST">
<td><input type="checkbox" name="creditcard" value="yes" CHECKED></td>
The value is set to checked, however if i uncheck the...
I perform a CFINSERT which performs without error. I then go and open my VFP database, however a get a file access denined when i try to open the VFP. I actually have to reboot. I can then get into the database and see that indeed my CFINSERT addded the data correctly. Obviously i do not...
Can anyone explain how to specify a date format for a particular field. For one field I need to set the date format to accept dd/mm/yyyy which is a combination of the European + long date format. For another field I need only mm/yyyy.
Thanks ahead of time,
kafka
Currently I have a table set up so that for every add to it my autonumber function automatically adds a new record in that table. is there any way to automatically update a second table so that for every add to the first table, a new record is created in the second table which is equal to the...
I would like to use a .gif. or .bmp as a data type for my database. Essentially on my site, a user would selecting a path for a .gif or .bmp file from their own directory. How do I set up my field to accept that image as a record for that field.
I have never done this so I am a bit hazy on...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.