| Moderator |
|
Bryan Valencia
209 Software
Home office in Manteca, CA
|
|
| Real Name: |
Bryan Valencia
|
| Primary Role: |
Coder |
| Title: |
Senior Software Engineer
|
| Company: |
Prestwood IT Solutions |
| Prestwood Staff: |
 Regular Member
|
| Website: |
www.prestwood.com/
|
| Joined: |
Dec 2007 (17 years ago) |
| Visits: | 3,076 |
| Birthday: |
July 8
|
|
|
|
 Message Boards Activity
23 posts. |
|
Thread 6 of 6 | | Thread Starter or a Reply (but not last) | | | Group |
Bryan Valencia |  Google Crawler Issues{Too Long!} | 
 7094
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?
|
 | 
Corel Paradox / ObjectPAL Coding | | |
Thread 3 of 6 | | Thread Starter or a Reply (but not last) | | | Group |
Bryan Valencia |  Column Modification Checklist{Too Long!} |
2842
Hits | 
Coding & OO | |
Thread 2 of 6 | | Thread Starter or a Reply (but not last) | | | Group |
Bryan Valencia | ASP Classic Suddenly fails {Too Long!}
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.
|
|
11331
Hits | 
ASP Classic Coding | |
Thread 1 of 6 | | Thread Starter or a Reply (but not last) | | | Group |
Bryan Valencia | RE: ASP Classic Suddenly failsActually, 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 Coding | |
 Knowledge Base Posts
|
|
| |
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.
(1 Comments
, last by Theessay.S )
|
Code |
KB Post |
7867
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.
(1 Comments
, last by ertime.l )
|
KB Post 10515
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!
|
KB Post 7366
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.
14 years ago, and updated 14 years ago
(2 Comments
, last by lowster11 )
|
KB Post 8843
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.
(2 Comments
, last by Hanvi.j )
|
Code 19940
Hits
|
C# (Visual C# & VS.Net)
|
 KB Comments
|
|
|
|
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?
|
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.
|
|
|
|
|
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?
|
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
|
|
|
|
|
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.
|
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. 
|
|
|
 Blog Topics:
|
|
|
|
|
Bryan.V
