garretts-ps-tips.blogspot.com

PEOPLESOFT TIPS & TRICKS

PEOPLESOFT TIPS and TRICKS. Monday, September 15, 2008. SQL - SQLExec returns null instead of a blank field. Sam found that the SQLExec function has some unexpected behaviour when used to retrieve a blank field. If the field it returns contains a blank space in the database PeopleSoft trims it and returns it as an empty string. This means you can’t tell whether the query returned a row but the field was blank or the query didn’t return any rows at all. SQL - Nested query referencing. FROM PS NAMES A.

http://garretts-ps-tips.blogspot.com/

OVERVIEW OF garretts-ps-tips.blogspot.com

TRAFFIC RANK

>1,000,000

REVIEWS

0

PAGES IN THIS WEBSITE

19

LINKS TO THIS WEBSITE

CONTACTS

ADDRESSES

SOCIAL LINKS

ONLINE SINCE

WEBSITE DETAILS

SEO

PAGES

SIMILAR SITES

TRAFFIC RANK FOR GARRETTS-PS-TIPS.BLOGSPOT.COM

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

December

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Saturday

TRAFFIC BY CITY

Sign up

CUSTOMER REVIEWS

Average Rating: 4.6 out of 5 with 5 reviews

5 star

3

4 star

2

3 star

0

2 star

0

1 star

0

Hey there! Start your review of garretts-ps-tips.blogspot.com

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

LOAD TIME

0.3 seconds

CONTACTS AT GARRETTS-PS-TIPS.BLOGSPOT.COM

ADD CONTACT

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

CONTENT

PAGES IN
THIS WEBSITE

19

SSL

EXTERNAL LINKS

0

SITE IP

216.58.194.161

LOAD TIME

0.286 sec

SCORE

6.2

PAGE TITLE

PEOPLESOFT TIPS & TRICKS | garretts-ps-tips.blogspot.com Reviews

<META> DESCRIPTION

PEOPLESOFT TIPS and TRICKS. Monday, September 15, 2008. SQL - SQLExec returns null instead of a blank field. Sam found that the SQLExec function has some unexpected behaviour when used to retrieve a blank field. If the field it returns contains a blank space in the database PeopleSoft trims it and returns it as an empty string. This means you can’t tell whether the query returned a row but the field was blank or the query didn’t return any rows at all. SQL - Nested query referencing. FROM PS NAMES A.

<META> KEYWORDS

1 posted by

2 garrett

3 no comments

4 peoplecode comparisons

5 or page

6 recommended

7 select max b effdt

8 and beffdt

9 select

10 and ceffdt =

CONTENT

Page content here

KEYWORDS ON PAGE

posted by,garrett,no comments,peoplecode comparisons,or page,recommended,select max b effdt,and beffdt,select *,and ceffdt =,fieldchange vs fieldedit,older posts,blog archive,michaels blog,portal navigation structure,application engine tracing,about me

SERVER

GSE

CONTENT-TYPE

utf-8

GOOGLE PREVIEW

PEOPLESOFT TIPS & TRICKS | garretts-ps-tips.blogspot.com Reviews

https://garretts-ps-tips.blogspot.com

PEOPLESOFT TIPS and TRICKS. Monday, September 15, 2008. SQL - SQLExec returns null instead of a blank field. Sam found that the SQLExec function has some unexpected behaviour when used to retrieve a blank field. If the field it returns contains a blank space in the database PeopleSoft trims it and returns it as an empty string. This means you can’t tell whether the query returned a row but the field was blank or the query didn’t return any rows at all. SQL - Nested query referencing. FROM PS NAMES A.

INTERNAL PAGES

garretts-ps-tips.blogspot.com

1

PEOPLESOFT TIPS & TRICKS: Peoplecode comparisons

http://garretts-ps-tips.blogspot.com/2008/09/peoplecode-comparisons.html

PEOPLESOFT TIPS and TRICKS. Monday, September 15, 2008. When comparing the current component/page/record with a particular component/page/record name, use COMPONENT. In the comparison. This way, if the object is renamed PeopleSoft will automatically update the name for us. It also allows the ‘Find Definition References’ to work better. If %Component = COMPONENT.UQ COMPONENT NAME then…. Subscribe to: Post Comments (Atom). SQL - SQLExec returns null instead of a blank fiel. SQL - Nested query referencing.

2

PEOPLESOFT TIPS & TRICKS: SQL - SQLExec returns null instead of a blank field

http://garretts-ps-tips.blogspot.com/2008/09/sql-sqlexec-returns-null-instead-of.html

PEOPLESOFT TIPS and TRICKS. Monday, September 15, 2008. SQL - SQLExec returns null instead of a blank field. Sam found that the SQLExec function has some unexpected behaviour when used to retrieve a blank field. If the field it returns contains a blank space in the database PeopleSoft trims it and returns it as an empty string. This means you can’t tell whether the query returned a row but the field was blank or the query didn’t return any rows at all. Subscribe to: Post Comments (Atom). Impact List for ...

3

PEOPLESOFT TIPS & TRICKS: When "Page data is inconsistent with database"

http://garretts-ps-tips.blogspot.com/2008/09/when-page-data-is-inconsistent-with.html

PEOPLESOFT TIPS and TRICKS. Monday, September 15, 2008. When "Page data is inconsistent with database". How we hate this one. PeopleSoft politely tells you that there is some data (being updated) that is inconsistent with what is in the database. It is not polite enough to tell you which. Here is some code to give you a clue. It returns all data that has changed on the Component. Place in the Component.SavePreChange event. Finds all data that is being updated in a component when saved. */. Level 0. */.

4

PEOPLESOFT TIPS & TRICKS: Help! No Matching Buffer Error - How to start.

http://garretts-ps-tips.blogspot.com/2008/09/help-no-matching-buffer-error-how-to.html

PEOPLESOFT TIPS and TRICKS. Monday, September 15, 2008. No Matching Buffer Error - How to start. Definately the most irritating error I come across, the "No matching buffer" error. I find this especially irritating as PeopleTools has found the error but refuses to give you any clue as to which scroll/data combination is causing it. But how to actually get into the component to take a look around? That damn error message is stopping you from opening the component. Subscribe to: Post Comments (Atom). No Ma...

5

PEOPLESOFT TIPS & TRICKS: Quotes for strings in SQL

http://garretts-ps-tips.blogspot.com/2008/09/quotes-for-strings-in-sql.html

PEOPLESOFT TIPS and TRICKS. Monday, September 15, 2008. Quotes for strings in SQL. If the field is character, we need to ensure the variable is enclosed by quotes, this will allow Oracle to utilise the indexed key for lookup. Example - &Condition = “where BUSINESS UNIT = ‘UQUNI’ and EMPLID = ‘“ &Emplid “’” i.e. putting single quotes around the variable &Emplid. Subscribe to: Post Comments (Atom). SQL - SQLExec returns null instead of a blank fiel. SQL - Nested query referencing. Quotes for strings in SQL.

UPGRADE TO PREMIUM TO VIEW 14 MORE

TOTAL PAGES IN THIS WEBSITE

19

OTHER SITES

garretts-acropolis.com

Garrett's Acropolis

This page uses frames, but your browser doesn't support them.

garretts-attic.net

Garrett's Attic

FAIL (the browser should render some flash content, not this). Welcome to Garrett's Attic, my personal web site! Started a new blog topic about effective work habits. Check it out here. Added a blog to the site. New posts will be made . randomly. Integrated a daily syndicated feed into the home page. Check back each day to see a new feed. The photo album is now available! It has a lot of great features. Check back from time to time to see the latest pictures. Feed of the day. What is a Noreaster?

garretts-clocktower.deviantart.com

Garretts-Clocktower - DeviantArt

Window.devicePixelRatio*screen.width 'x' window.devicePixelRatio*screen.height) :(screen.width 'x' screen.height) ; this.removeAttribute('onclick')" class="mi". Window.devicePixelRatio*screen.width 'x' window.devicePixelRatio*screen.height) :(screen.width 'x' screen.height) ; this.removeAttribute('onclick')". Join DeviantArt for FREE. Forgot Password or Username? Founded 2 Years ago. This is a group dedicated to the best thief of all time: Garrett! Founded 2 Years ago. Aug 16, 2014. Div div.gmbutton2...

garretts-garretts.blogspot.com

The Garrett Family

Saturday, January 14, 2012. For everyone who was interested in my homeade bread recipe, here it is! 1 cup very warm water. 1 cup brown sugar or honey ( I use honey). 1/2 cup of oil. 4 1/2 cups warm water. 12-14 cups whole wheat flour*. Divide into 4 pieces and form loaves. (I grease my pans with crisco and use a lot on my hands because I leave my dough a little sticky. It's much easier to handle with a good amount! Paint tops with crisco, butter or oil if desired. Or is that a pretty good deal? Camryn tu...

garretts-kidstrong.org

Home

A 501(c)(3) non-profit organization - Your donations can be tax deductible! Is Oct. 21 and it's time to sign up for the pedicabs. Contact is Colleen at smilesmom@att.net,. Or by phone 825-7906. You can also contact Colleen by leaving a Facebook message. This is the 10th year that LiveStrong is doing this event and the 8th year that Garrett's KidStrong is involved in it. We have enough space for 30 kids and their family members. A Wish Come True! We received a $5000.00 donation. We now have a Wish List.

garretts-ps-tips.blogspot.com

PEOPLESOFT TIPS & TRICKS

PEOPLESOFT TIPS and TRICKS. Monday, September 15, 2008. SQL - SQLExec returns null instead of a blank field. Sam found that the SQLExec function has some unexpected behaviour when used to retrieve a blank field. If the field it returns contains a blank space in the database PeopleSoft trims it and returns it as an empty string. This means you can’t tell whether the query returned a row but the field was blank or the query didn’t return any rows at all. SQL - Nested query referencing. FROM PS NAMES A.

garretts-takeiteasy.blogspot.com

Take It Easy

Monday, August 1, 2016. Christopher was baptized this weekend and we had such a nice service for him. Eric was baptized the same day, so we were surrounded by family and friends. I really enjoyed the filling of love present in the room. Sunday, July 10, 2016. We checked in the hotel that evening and I had dinner duty for the first night. Kady had dinner for the second night. On Saturday we got up, had a nice breakfast at the hotel and left for Legoland. I got separated from Cory and the big kids righ...

garretts.biz

Index of /

Apache Server at www.garretts.biz Port 80.

garretts.ie

Garretts Butchers | Quality Butchers Limerick, Butchers in Limerick, Butcher Online, Meats Ireland

Our meat is traced from the farm gate to your plate. Team Garretts - Stephen Boyce. Team Garretts - Elaine. Team Garretts - Andrew. Team Garretts - Jozef. Team Garretts - Laura Greaney. Holidays - Wild Atlantic Way. Team Garretts - Ciaran. Listed Top 100 Stores. Buy Your Meat Online. Top 30 Stores in Ireland. Roast Pork Belly Recipe. Team Garretts - Eoin. Spring Lamb Chop Recipe! Team Garretts - Deirdre. Team Garretts - Roza. Team Garretts - Gosia. Our New Butcher Wall. Team Garretts - Tracey Preston.

garretts.net

Index of /

garretts.us

404 (Page Not Found) Error - Ever feel like you're in the wrong place?

Ever feel you're in the wrong place. 404 (Page Not Found) Error. If you're the site owner,. One of two things happened:. 1) You entered an incorrect URL into your browser's address bar, or. 2) You haven't uploaded content. If you're a visitor. And not sure what happened:. 1) You entered or copied the URL incorrectly or. 2) The link you used to get here is faulty. It's an excellent idea to let the link owner know.).