codeprada's Profile User Rating: *****

Reputation: 946 Master
Group:
Mentors
Active Posts:
2,360 (1.84 per day)
Joined:
15-February 11
Profile Views:
34,731
Last Active:
User is offline Aug 05 2014 03:17 PM
Currently:
Offline

Previous Fields

Country:
AG
OS Preference:
Windows
Favorite Browser:
Chrome
Favorite Processor:
AMD
Favorite Gaming Platform:
XBox
Your Car:
Toyota
Dream Kudos:
775
Expert In:
PHP
Icon   codeprada has not set their status

Posts I've Made

  1. In Topic: mysql vbnet prevent duplicate record

    Posted 5 Aug 2014

    Hello there,
    You should use a UNIQUE constraint and apply it on your DATETIME field. This would require you to alter the table. This works but practically I won't suggest you do. The best option is to check it manually. I don't believe appointments are going to be a minute long and the UNIQUE constraint would only account for that specific time. Plus using the UNIQUE constraint would mean that you would have to delete your appointments after they're finished in case someone else wants to book that time in the future. In my opinion your best bet would be to check it manually. An appointment or booking should have an end time also.
    I haven't used MySQL in a while so forgive me if there's an error here but this is the logic
    IF (SELECT 1=0 FROM YourTable WHERE `appointment_starttime` >= requested_time AND `appointment_endtime` < requested_time) THEN
    BEGIN
          
          INSERT INTO YourTable ..................
    END
    
    


    This is of course a simple solution because remember bookings can overlap. It's rare you're going to have someone book the exact same time down the minute all the time. For instance someone's booking can't end in the middle of another person's booking. Nonetheless you see that you can perform IF THEN ELSE queries with MySQL.
  2. In Topic: Error conversion from string to type Double is invalid

    Posted 5 Aug 2014

    Hello there,
    This is because an implicit cast isn't being performed. You'll have to do the cast manually. Check out the Convert.ToDouble method. It has many other overloaded methods that you can use to do many conversions. Play around with the Convert class too.

    The other alternative which will make your code run a lot cleaner is the Double.TryParse method. It returns a Boolean that states whether or not the conversion was done so that you can basically perform error checking.

    Also don't forget to use
    Code Tags
    
    .
  3. In Topic: PHP affected_rows doesn't work

    Posted 26 Feb 2014

    Well technically there's a redirect directly after your echo. Remember all PHP code is ran before anything even reaches the client/browser. Therefore PHP would have already executed the redirect thus not displaying the echo statement you have there.

    Try removing the header('location ....') line to confirm that rows are actually being deleted OR pass the number of rows being deleted as a GET request to the page you're redirecting to.

    header('location: index.php?result=' . $delete->affected_rows);
    
    
  4. In Topic: Delegate wrong return type

    Posted 26 Feb 2014

    Where are the other delegates? So far I don't see a delegate that accepts a string and returns a string in ConsoleAPI.cs. If there isn't one then that's your problem right there.
    public delegate string <DelegateName>(string str);
    
  5. In Topic: Text Box Change Event

    Posted 26 Feb 2014

    Create a handler for the KeyPress event and then check which key was pressed within the e.KeyChar (don't quote me on the variable here, all from memory). If the KeyChar is not allowed then change e.Handled to true. This will ensure that the key is not processed.

    You can also set the same handler for all of your 81 text boxes' KeyPress event.

My Information

Member Title:
Changed Man With Different Priorities
Age:
23 years old
Birthday:
February 13, 1991
Gender:
Location:
Antigua
Interests:
Programming,
My girlfriend,
Staying fit,
Football (Soccer),
Gaming,
Cricket
Years Programming:
6
Programming Languages:
Advanced:
PHP,
C,
C++,
Javascript,
Java,
HTML/CSS,
C#

Intermediate:
VB.NET,
SQL

Beginner:
Perl
Python

Contact Information

E-mail:
Private
Website URL:
Website URL  http://codeprada.com
Twitter:
coder_
Xfire:
codeprada

Comments

Page 1 of 1
  1. Photo

    jesicalbaby Icon

    16 Sep 2013 - 14:40
    Hello
    My name is Miss jesical,
    i saw your profile today
    and,i fill more interest to contact you ,
    i will like you to please send me
    an email via (jesicalduncan22@yahoo.com)
    for me to send you my picture
    jesicalduncan22@yahoo.com
  2. Photo

    defiance Icon

    22 Feb 2012 - 14:47
    codeprada when you have time please read your priv mail :)
  3. Photo

    Jstall Icon

    31 Jan 2012 - 06:12
    Congrats on the promotion! Very very well deserved dude.
  4. Photo

    smohd Icon

    31 Jan 2012 - 03:59
    Welcome to the club! Now its my time to welcome you :)
  5. Photo

    smohd Icon

    30 Oct 2011 - 12:52
    Thanks mate, Looks cool... I missed my experts club ;)
    But you seem to be busy these days.
  6. Photo

    RudiVisser Icon

    05 Sep 2011 - 04:32
    Thanks :)
  7. Photo

    RudiVisser Icon

    05 Aug 2011 - 10:11
    Thanking you - Once I've finished off the 2x CMS Tutorials + got time to spend on more daily articles I think it will be even better! Just can't keep updating my signature with every single one :D
  8. Photo

    smohd Icon

    03 Jul 2011 - 09:37
    Thanks
  9. Photo

    smohd Icon

    20 Jun 2011 - 14:43
    I see it now, nice work :)
  10. Photo

    smohd Icon

    20 Jun 2011 - 11:49
    Hi, but everytime I see you online helping, why they remove it from you? Did they mention any reason? or just system error?
  11. Photo

    smohd Icon

    20 Jun 2011 - 11:17
    Hey, what happens to expert badge?
  12. Photo

    codeprada Icon

    16 Jun 2011 - 03:36
    Thanks, so the link's been doing it's job :)
  13. Photo

    Ace26 Icon

    16 Jun 2011 - 01:53
    Hey there, howdy? I like one of your signature links that says hell is real. Are you a believer in Jesus Christ as your Lord and personal saviour?
    If yes then I'd say keep up the good work and stay strong in the faith, my brother in the Lord.
    Nice to meet a fellow christian geek.
  14. Photo

    Vip3rousmango Icon

    13 Apr 2011 - 12:12
    Thanks for the rep! :)
Page 1 of 1