I.T. Discussion Community!
Bryan Valencia -Collapse +Expand
Employee
-Collapse +Expand
Bryan.V
-Collapse +Expand Profile◄╣
Member Info
Member Narration

POSTS:
MB Posts (23)
KB Posts (27)
KB Comments (4)
Blog (2 Topics)

KBPOSTSBYTYPE:
Tech Articles
Code Snippets (9)

Search Bryan.V:

Advanced
      Print This!  
Business Account . . .
Moderator
Bryan Valencia
209 Software
Home office in Manteca, CA
Rank: Captain



Real Name:  Bryan Valencia
Primary Role:  Coder
Title:  Senior Software Engineer
Company:  Prestwood IT Solutions
Website:  www.prestwood.com/
Joined: Dec 2007 (10 years ago)
Visits: 1,799
Member Points1,145
Birthday:  July 8
Web Presence
LinkedIn, Bryan On LinkedIn (Visit Me)
Website, Software Services (http://209software.com/)
Website, Visual Studio Journey (http://vstudiojourney.blogspot.com/)

Message Boards Activity

23 posts.
More...

Thread 6 of 6
Thread Starter or a Reply (but not last)  Group

Bryan Valencia
Google Crawler Issues
{Too Long!}
7 years ago

dency.p
{Too Long!}
12 months ago
Nothing New Since Your Last Visit
5374
Hits

Website Design & Hosting

Thread 5 of 6
Thread Starter or a Reply (but not last)  Group

Bryan Valencia
RE: How to do a FULL JOIN in SQL ...
I just read that in paradox the OUTER keyword is optional. So lets say you want to join customers and visitors from a website.  They are not mutually exclusive and you're matching by email address. select visitors.name, visitors.email, customers.name, customers.email from visitors , full outer join customers on upper(customers.email)=upper(visitors.email), You'll get 4 columns, like this... Customer_name, Customer_email, null null    --this entry only in customers null, null Visitor_name, Visitor_email   --this entry only in visitors Customer_name, Customer_email,Visitor_name, Visitor_email --this entry in both like this... Bob A Fett, Bobafet@email.com, NULL, NULL NULL, NULL, Claude O'vercast, cloudy@email.com June C. june@email.com, June, June@EMAIL.com Does this help?
Posted to MB Topic: QBE & SQL « Paradox Board
44 months ago
Nothing New Since Your Last Visit
Corel Paradox / ObjectPAL Coding

Thread 3 of 6
Thread Starter or a Reply (but not last)  Group

Bryan Valencia
Column Modification Checklist
{Too Long!}
Posted to MB Topic: Coding Techniques « Coder Board
45 months ago
Nothing New Since Your Last Visit
1792
Hits

Coding & OO

Thread 2 of 6
Thread Starter or a Reply (but not last)  Group

Bryan Valencia
ASP Classic Suddenly fails
{Too Long!}
7 years ago

Bryan.V
Actually, after much anguish, I found that the latest MS patch had inadvertently changed my site from Low(iis) to Medium(Pooled) Setting it back did the trick. asp classic sites dont work on medium
7 years ago
Nothing New Since Your Last Visit
9871
Hits

ASP Classic Coding

Thread 1 of 6
Thread Starter or a Reply (but not last)  Group

Bryan Valencia
RE: ASP Classic Suddenly fails
Actually, after much anguish, I found that the latest MS patch had inadvertently changed my site from Low(iis) to Medium(Pooled) Setting it back did the trick. asp classic sites dont work on medium
7 years ago
Nothing New Since Your Last Visit
ASP Classic Coding
More...



Knowledge Base Posts

More...
  KB Article    

Bryan Valencia
1. Easy SQL Server Backup Script

Learn how to make an easy SQL Server Script that will automatically back up all your databases in a simple way.

Posted to KB Topic: Microsoft SQL Server
53 months ago
(1 Comments , last by Theessay.S )

Code

KB Post
Nothing New Since Your Last Visit
4556
Hits

DBA, Databases, & Data

Bryan Valencia
2. Using Web Safe Fonts in CSS

If you are editing the stylesheet in Visual Web Developer, and you access the font-family dropdown, Microsoft shows 3 common web-safe fonts and then every font in your system. 

This is dumb.  Most of us designers have many, many fonts that the average web browsing public has never heard of. 

Therefore, I present this list of Web Safe Fonts.  Use this list in the font-family  settings to achieve the effect you want, with maximum web compatibility.

Posted to KB Topic: Website Design
6 years ago

KB Post
Nothing New Since Your Last Visit
6102
Hits

Website Design & Hosting

Bryan Valencia
3. ASP.NET Cheat Sheet

Here's some copy-and-paste code that I use weekly.  Bookmark it and save yourself hours!

Posted to KB Topic: WebForms (ASP.Net)
7 years ago

KB Post
Nothing New Since Your Last Visit
5239
Hits

VB.Net Language

Bryan Valencia
4. Which Development Tool would YOU use?

Maybe I'm cynical, but as a developer meeting with a prospective client to gather requirements, I always wait for that one "gotcha" that turns a simple, straightforward project into a potential daymare. 

Posted to KB Topic: Coding & OO
7 years ago, and updated 7 years ago
(2 Comments , last by lowster11 )

KB Post
Nothing New Since Your Last Visit
5800
Hits

Coding & OO

Bryan Valencia
5. Consuming an RSS feed in ASP.NET

Using this quickie code snippet, you can attach an ASP:Gridview  to an external RSS Feed.

All you need to accomplish this is the URL of a usable feed.

Posted to KB Topic: WebForms Coding Tasks
7 years ago
(1 Comments , last by Louis.M )

Code
Nothing New Since Your Last Visit
16650
Hits

C# (Visual C# & VS.Net)
More...

KB Comments

More...
Read +Add Comment
Thanks for that - I am there.  I got a thing called Netbeans that uses the Java/Swing approach.  Is there a better IDE for this sort of thing?
Posted 7 years ago
Regarding...
Which Development Tool would YOU use?
Maybe I'm cynical, but as a developer meeting with a prospective client to gather requirements, I always wait for that one "gotcha" that turns a simple, straightforward project into a potential daymare. 
Read +Add Comment
Mike, is there any way we can attach the current version of that MDB file to this article, in case it becomes unavailable at some point? 
Posted 7 years ago
Regarding...
Geolocation: Step by Step
I need to perform a search for all the (jobs, contractors, appraisers, deli's) within 50 miles of my home.  How can I do that? This tutorial will guide you through the process step-by-step and provide you with the ability to input any two zip codes and get back the distance based on latitude and longitude. The skills and tools needed for this task are simple...
  • basic MSSQL skills
  • Read +Add Comment
    Interesting. I had heard that some older browsers ignore it, but not that there is an alternate way of displaying it.  Since there are so many browsers, and open-source variants, I can't really answer that with a definite answer.
    Posted 8 years ago
    Regarding...
    SHORTCUT ICON
    Get rid of the boring default icon on your website.  Add a custom icon!  Most browsers support .ico and the most popular ones will show any standard web image.  Follow this easy step by step to add one to your web page or site. Example: This is Prestwood.com's icon. 
    More...

    Blog Topics:

      KB Article    

    Bryan Valencia
    1. ASP.NET and SQL Server: Chapter 1: Displaying A Gridview of SQL Server Data

    This is a quick topic to get you started presenting data in a grid in an ASP.NET web page.

    7 years ago

    Blog
    Nothing New Since Your Last Visit
    6417
    Hits

    Computer Industry

    Bryan Valencia
    2. How to Create a Crappy Web Site

    Ok, no one really needs information on how to make the worst possible web site.  This article was written as a guide how not to do a web page for your business.  As a professional web designer I am well-versed in all the nerdy ways required to carve a web site out of solid stone.  What I offer here is a humorous attempt to get you thinking about the things a business needs to consider before creating or redesigning your web page.

    7 years ago

    Blog
    Nothing New Since Your Last Visit
    5279
    Hits

    Computer Industry
    -
       Contact Us!
     
    PrestwoodBoards.com was developed and is maintainted by me. Do you have a question or suggestion? Do you see a problem? Contact me now. My goal is to build an ad-free and spam-free source of I.T. information with many contributers (ok to promote your website/company in your bio). Yes, my company Prestwood IT Solutions is mentioned in my bio which shows with every post, but you can contribute and promote your pet project too!

    1,890 People Online Now!!  
    Sign In to see who's online now!  Not a member? Join now. It's free!
    Show more stats...


    ©1995-2017 PrestwoodBoards  [Security & Privacy]
    Professional IT Services: Coding | Websites | Computer Tech