Go Back   CodingForums.com > Search Forums
Reload this Page Search Results

Before you post, read our: Rules & Posting Guidelines

Page 1 of 3 1 23
Showing results 1 to 25 of 70
Search took 0.12 seconds. Search: Posts Made By: awayne96
Forum: MySQL 11-06-2012, 09:07 PM
Replies: 4
Views: 684
Posted By awayne96
Thanks for the response Old Pedant! I do...

Thanks for the response Old Pedant!

I do have an ADDED and UPDATED in the record...

What you posted will work for the searching purpose... But what I need is when the member that posted an item...
Forum: MySQL 11-03-2012, 04:37 AM
Replies: 4
Views: 684
Posted By awayne96
disable/archive data from being searched???

I'm trying to figure out the best way to disable/archive data from being searched.

I will have members making postings and say after 5 days from when it was originally posted I don't want that...
Forum: Perl/ CGI 09-15-2010, 08:15 PM
Replies: 0
Views: 704
Posted By awayne96
cgi/mysql based ratings script/code?

I have been looking for a ratings script/code for my site so that members can submit a rating for another company. I would like it to be like an ebay style rating/feedback setting that allows 3...
Forum: Perl/ CGI 01-06-2010, 07:55 AM
Replies: 1
Views: 984
Posted By awayne96
Ok, so I figured out that I needed " instead of '...

Ok, so I figured out that I needed " instead of ' on the my $body line for it to work.

Now, I am putting all of my email body info on 1 line with <br> code to have a break... is that the best...
Forum: Perl/ CGI 01-06-2010, 07:10 AM
Replies: 1
Views: 984
Posted By awayne96
adding data to body of email being sent?

So I was having the problem with the CGI script sending an email which has now been resolved.... but now another question.

I want to have some data that is coming from the form that is being...
Forum: Perl/ CGI 12-18-2009, 04:37 PM
Replies: 38
Views: 5,208
Posted By awayne96
Well after all of the problems I have had I ended...

Well after all of the problems I have had I ended up putting an actual email field on the form related to the departures that writes to that table.

This will also allow the user to have...
Forum: Perl/ CGI 12-15-2009, 06:46 AM
Replies: 38
Views: 5,208
Posted By awayne96
Login in both the departures and profiles are the...

Login in both the departures and profiles are the same. If a user has a departures listed table, it has there login in the departures login field which matches the login in the profiles table.

So...
Forum: Perl/ CGI 12-15-2009, 12:26 AM
Replies: 38
Views: 5,208
Posted By awayne96
What I had posted above is what I used... that is...

What I had posted above is what I used... that is the error I got when I tried it.

I tried many different combinations to try to get it to work and no go with all of them.... Some would give me...
Forum: Perl/ CGI 12-14-2009, 03:42 AM
Replies: 38
Views: 5,208
Posted By awayne96
Thanks for the reply! I am running the following...

Thanks for the reply! I am running the following code now:

my $profiles_sth = $dbh->prepare("SELECT * FROM `departures`
WHERE `departures_states` = ?
...
Forum: Perl/ CGI 12-13-2009, 03:51 AM
Replies: 38
Views: 5,208
Posted By awayne96
I wish this would not have been like this because...

I wish this would not have been like this because it would have saved me and you (since you were helping me) alot of headaches.
Forum: Perl/ CGI 12-13-2009, 03:49 AM
Replies: 38
Views: 5,208
Posted By awayne96
That was designed by someone else like that.... ...

That was designed by someone else like that.... That is why I didn't realize there wasn't an email field in the departures table.... I guess I could change just change it from profiles_sth to...
Forum: Perl/ CGI 12-13-2009, 03:15 AM
Replies: 38
Views: 5,208
Posted By awayne96
my $profiles_sth = $dbh->prepare("SELECT * FROM...

my $profiles_sth = $dbh->prepare("SELECT * FROM `departures`
WHERE `departures_states` = ?
AND `departures_state_region` = ?" )
...
Forum: Perl/ CGI 12-13-2009, 02:56 AM
Replies: 38
Views: 5,208
Posted By awayne96
Sorry about that, for some reason I uploaded the...

Sorry about that, for some reason I uploaded the wrong profile table... Here is the correct one:

http://i879.photobucket.com/albums/ab355/wj2005/profilestable-1.jpg
Forum: Perl/ CGI 12-13-2009, 01:40 AM
Replies: 38
Views: 5,208
Posted By awayne96
Here are images of both tables ...

Here are images of both tables

http://i879.photobucket.com/albums/ab355/wj2005/departurestable.jpg

http://i879.photobucket.com/albums/ab355/wj2005/profilestable.jpg

This is the code that I...
Forum: Perl/ CGI 12-12-2009, 08:38 PM
Replies: 38
Views: 5,208
Posted By awayne96
So I have: $query = "SELECT email FROM...

So I have:

$query = "SELECT email FROM profiles WHERE login = 'login'";

But I also tried this:

$email = ("SELECT 'email' FROM 'profiles' WHERE 'login' = 'login'");

neither one of these...
Forum: Perl/ CGI 12-12-2009, 07:51 PM
Replies: 38
Views: 5,208
Posted By awayne96
Do I need to use a temp table to accomplish this?...

Do I need to use a temp table to accomplish this? From what I have been reading I would. I have tried several different things and still continue to get no address found in header.
Forum: Perl/ CGI 12-12-2009, 06:21 AM
Replies: 38
Views: 5,208
Posted By awayne96
I started to build what I thought would work to...

I started to build what I thought would work to query the profile database. I am getting no addresses found in header message with what I have:

my $profiles_sth = $dbh->prepare("SELECT * FROM...
Forum: Perl/ CGI 12-12-2009, 01:17 AM
Replies: 38
Views: 5,208
Posted By awayne96
Not every user gets notified when its posted.... ...

Not every user gets notified when its posted.... Only the users that match with what the posting user has available. It is match state1 & state2 to the departures table.

I just figured it would...
Forum: Perl/ CGI 12-12-2009, 12:55 AM
Replies: 38
Views: 5,208
Posted By awayne96
Ok, so I tested it by using another field to...

Ok, so I tested it by using another field to input the email address in the departures table.

Ran the script and it worked.

I am doing this from another computer right now so it still needs...
Forum: Perl/ CGI 12-12-2009, 12:46 AM
Replies: 38
Views: 5,208
Posted By awayne96
Do I need to add a hidden field to input the...

Do I need to add a hidden field to input the users email address to the departures table and into a field 'email'?
Forum: Perl/ CGI 12-12-2009, 12:33 AM
Replies: 38
Views: 5,208
Posted By awayne96
Here is the output: $VAR1 = { ...

Here is the output:

$VAR1 = {
'departures_dispatch_phone' => '3332221111',
'departures_state_region' => 'Florida',
'departures_truck_name' => 'test',
...
Forum: Perl/ CGI 12-11-2009, 11:22 PM
Replies: 38
Views: 5,208
Posted By awayne96
Well, I created the cgi file with the above code...

Well, I created the cgi file with the above code and I got this error:

no email retrived from db at line 83.

So I was wondering if login and firstname would work so I put the error message next...
Forum: Perl/ CGI 12-11-2009, 07:46 PM
Replies: 38
Views: 5,208
Posted By awayne96
I know that there is my email address in there...

I know that there is my email address in there formatted me@mydomain.com.

We I run the script, it should be sending me an email since I am setup to be notified but nothing was sent.

I did look...
Forum: Perl/ CGI 12-11-2009, 05:15 PM
Replies: 38
Views: 5,208
Posted By awayne96
No Problem FishMonger, I appreciate the help when...

No Problem FishMonger, I appreciate the help when your able to get to it!

I made the changes and actually took out the part of the script that is sending the message to the internal system to try...
Forum: Perl/ CGI 12-10-2009, 04:28 AM
Replies: 38
Views: 5,208
Posted By awayne96
OK, so working on this a bit more I got it to...

OK, so working on this a bit more I got it to work 100% when I had an actual email address entered on line my $to = 'email@mydomain.com';

But what I need it to do is to send an email to the users...
Showing results 1 to 25 of 70
Page 1 of 3 1 23

 
Forum Jump

All times are GMT +1. The time now is 06:04 AM.