Hi
Just thought I say thanks as this has helped me. I had my sales email address in the mail header and found some emails have been going in to spam boxes and therefore missed. I now have the comany name in from field.
Always the first port of call for help and never failed me yet!!!
Thanks again.
badvoc
Last Activity: Apr 3 '09, 04:14 PM
Joined: Sep 9 '07
Location:
-
Well, this is what I have.
ALTER TABLE accommodation ADD CONSTRAINT minmaxrate_chec k CHECK (minrate < maxrate)
This causes and error.
ALTER TABLE statement conficted with TABLE CHECK constraint 'minmaxrate_che ck'. The conflict occured in databese....
Update.
As I was writing this I noticed that the mminrate and maxrate were set to varchar!!! I have altered them to money and...Leave a comment:
-
[font=Arial]The data in question is in the same table and same row just different columns.[/font]
[font=Arial]I don't have a great deal as I'm struggling with the syntax.[/font]
To be honest I haven't used any constraints other than P and F Keys before.
I would have thought that a simple if x is > y then do not allow the insert else insert it.
I have sql server 2000 with enterprise manager...Leave a comment:
-
[font=Arial]Cheers for the reply[/font]
The data is being inserted from a web page. Under normal circumstances I would just validate the info from the web side of things but I am doing a project that requires database skills to be evaluated.
I am currently looking at an after trigger and not having a great deal of success. I wanted to use a check_constrain t as this sounded the easiest way but again not much success....Leave a comment:
-
Limiting integers
Hi,
I am trying to prevent one integer (minrate) exceeding the value of (maxrate) in sql server 2000.
The table is to store details relating to the cost of accommodation. When adding new rows I want to make sure the min rate cannot exceed the max rate.
I have searched the net but have not turned up any positive results.
I have tried a check constraint and trigger but cannot find anything that... -
[font=Arial]Cheers Ronald. I was helping a friend with a project he is doing for his degree and we sort of sorted it but went with a different method that was easier for him to understand and implement into his project.[/font]
Many thanksLeave a comment:
-
Thanks I'll have a look and come back to you.
I am only looking for pointers and advice not answers so thank you for directing me to help rather than showing the answers. I have used this forum before and it's always my first point of call after google that is.
CheersLeave a comment:
-
Drop down box onchange in php
Sorry about the title wasn't sure how to describe my issue in short form.
My problem is this.
I have a dropdown box that is populated from a mySQL database. The reason for this is there are a significant number of options available and much easier to do than code all the options individually.
When the user clicks an option in the drop down box I want the details of some text boxes to change according to the... -
Cheers, the latter suggestion is probably what i will go for. I am not keen on blocking browsers either.
I'll try and work on fixing whats wrong.
I have also noticed that firefox has issues with style sheets, or should I say it has issues with the way I have written my style sheets. Is there such thing as a tutorial or some tips somewhere to help site building for firefox.
CheersLeave a comment:
-
Disabling browsers
Hello to all.
I have an issue with firefox browser and would like to stop visitors using it until I have my problem fixed.
Is there such php code to do this. I don't want to stop it perminatly just until my code is right.
Unless someone knows why I have this problem...
My site involves placing an order and when an order is placed using firefox 2 orders are generated, the one the visitor places... -
I have sorted this too.
I am on to another part so if help is needed I will start a new topic if needed.
CheersLeave a comment:
-
Right I seem to have done it again. I have sort out the auto increment an am using 1 table.
The issue i have is with my 4 zeros. I want the order number to be made up of 4 letters and 6 numbers, so the 4 zeros are included in the number not just added to it as I have done.
[PHP] $order_id="IPRD " .sprintf("%04d" , $order_id) . $cnt;[/PHP]
This is what I have but am sure it was different...Leave a comment:
-
After messing about with my design I have lost the section where I generate my order number so I am starting again and using the one table, as suggested, with an auto incrementing column to generate the ID. I then have an order_number column that stores the full order number.
I am unsure of how to call the last id used and add one to it to create the next value. I know about the auto increment feature but as I am not using that number...Leave a comment:
-
Yeah I have the cnt set to auto incremant. i am using a seperate table as I couldn't get it to work so tried it as an option and it is still there.
I also want to store the actual order number which is prefixed with a 4 letters thus making it different to the id.
I suppose now its working I could just go back to the one table and use the id column and auto increment that..
Cheers...Leave a comment:
-
Sorry about the title, I did try to add some detail but now see that it is annoying to see help in titles.
I'm sure I'll be back.
ThanksLeave a comment:
-
[QUOTE=badvoc]// Update counter for order id's
$sql = "UPDATE i_counter SET cnt = $cnt";
$result = mysql_query($sq l);
[/PHP]
I seem to have solved this by using insert into instead of update.
But thanks if you have stopped by to help.Leave a comment:
-
Creating a unique order number using auto increment.
Hi,
I have had some good fortune on this site so I am back and I must iterate I am a beginer.
I am having some problems getting to grips with the right technique to manage variables and adding a unique order number to a customer order form.
I have 4 stages to my order form.
Stage 1 involves the user selecting a link based on what they want. The link then sets 2 variables. $type and $fault based... -
Thanks,
I have a big project coming up shortly so I'll be sure to stop by.
Thanks again
BadvocLeave a comment:
-
We have a winner.
Sorted it. With you mentioning permssions I noticed that the permissions on the folders in the Testing folder were all 777. I have set all the folders in the main directory to the same and it works. I will now test which ones need to have those levels of permission and reset the others.
Many thanks for you time and help. Its very much appreciated.
BadvocLeave a comment:
-
I hate to say it but the files are there and both have permissions set to 755.
I have even tried 777 but no good.
I don't understand why, when i have exactly the same files on the same server just at a sub level in the file directory, I get the error message.
Would it be worth deleting the whole lot from the server and re uploading it. (back ups made!!!)
ThanksLeave a comment:
No activity results to display
Leave a comment: