Messages

31

Web Server - Share Knowledge / oAuth v1 - Connecting to QuickBooks Online example

« on: May 16, 2014, 12:45:01 PM »

Hi All,
For my application to connect to QuickBooks Online I needed oAuth v1 capabilities in my app.  Figuring this out has had me pulling my hair out.  The documentation for oAuth is pretty complicated and not real clear on several points.  

So to save someone else that frustration, attached is an example app for connecting to QuickBooks Online using oAuth v1.  I have another project coming that will use oAuth v2 so when I get that done I will share an example as well.  

FYI, the following is required for this example

• NT 8.11 (used for a new flag of net:php in the encryptWebString)
• xFiles
• Cryptonite

NOTE: You have to be signed in to download the file.

Hopefully this helps someone else!

Debra

[attachment deleted by admin]

32

Web Server - Ask For Help / Re: Filtering a dropList

« on: May 14, 2014, 05:07:43 AM »

WOS:DisplayOrder <= 2 AND WOS:DisplayOrder = 5 is impossible

I think you are wanting this

Code: [Select]

WOS:DisplayOrder <= 2 OR WOS:DisplayOrder = 5

33

Web Server - Ask For Help / Re: Google Places JavaScript API

« on: May 12, 2014, 09:14:53 AM »

I did something similar using an example from Google and ran into a few issues with it.
I ended up getting it to work but only on pages that open as a link. 
Bruce was going to help out with it...  see this post
http://www.nettalkcentral.com/index.php?option=com_smf&Itemid=36&topic=5483.0
In the end my javascript file looked the one attached, this corrected the issue of the auto complete only working one time.



[attachment deleted by admin]

34

Web Server - Ask For Help / Re: 8.09 ImageMap

« on: May 12, 2014, 05:23:44 AM »

I could make use of this ability as well 

35

Web Server - Ask For Help / Re: Google Places JavaScript API

« on: May 12, 2014, 05:19:32 AM »

Yes, what aspect of the API are you wanting to work with?

Thanks

Debra

36

Web Server - Ask For Help / Re: Call Form with no browse from Static Page Link

« on: May 07, 2014, 05:20:41 AM »

I think you have your quotes in the wrong spots.  Try it like this.
I removed the ' from

<a href="'My

and added a &' to this

SysID,60)">

'<a href="MyChurchProfile?change+btn=change&_bidv_=' &p_web.AddBrowseValue('dmemain','Family',FAM:Key_SysID,60)&'">'

Hope that helps

Debra

37

Web Server - Ask For Help / Re: Function for Percent Encoding?

« on: May 01, 2014, 12:19:09 PM »

Thank you!!!

38

Web Server - Ask For Help / Re: MS SQL Tables Locking Part 2

« on: May 01, 2014, 06:10:23 AM »

Hi Trent, fill factor will be less important on a PK that is sequentially numbered.  But I would still turn off the Page Lock to see if that helps.
The other thing you could do to find indexes that are needed is to run SQL Profiler, have it log all the transactions to a table.  Then you can find the "Database Engine Tuning Advisor" in the tools menu of Management Studio.  Run this tool over the table profiler created.  It may have some suggestions for your indexing as well.  These options are available on 2005.

39

Web Server - Ask For Help / Re: MS SQL Tables Locking Part 2

« on: April 30, 2014, 07:35:08 PM »

You do not need the most expensive queries to know which indexes to turn off Page Locking on.  And also adjust your fill factor.  Do it on your Primary key's on the tables that have the most data being entered.  The fill factor and page locking are different performance tuning options than what you get with missing indexes.

As for isolation level, its can; but you want it to be read committed.  Blocking is normally either transactions being started and left open, indexing issues, or improper queries.

Do you use sequential numbers or guids for your primary keys?

40

Web Server - Ask For Help / Re: MS SQL Tables Locking Part 2

« on: April 30, 2014, 06:49:08 PM »

This is totally from memory, it has been a long time since I was in 2005.  But I think that activity monitor is  in the Object Explorer (aka the slide out window usually on the left side where you see your server and databases).  I think its toward the bottom by the or inside of the SQL Server Agent menu.

Have you looked at turning off the Page Locking on your high transaction table indexes?

41

Web Server - Ask For Help / Re: Checking Fields in a form

« on: April 30, 2014, 05:21:22 PM »

p_web.SetSessionValue('CVF:EditsCompleted','EditsCompl')

But this does not seem to work?

You almost have it right, try it like this (notice no quotes in the second part)

Code: [Select]

p_web.SetSessionValue('CVF:EditsCompleted',EditsCompl)
So after you fix that, do what michelis said and make sure the items on the screen you want refreshed are listed in the "Reset" list.  Find this right under your check box to "Send new value to server" where you enter your code.

42

Web Server - Ask For Help / Re: MS SQL Tables Locking

« on: April 30, 2014, 05:10:02 PM »

I am not sure if that query will work in 2005, some of those dynamic management views may be new in 2008. 
This link gives an explanation of 2005 activity monitor  http://technet.microsoft.com/en-us/library/ms175518(v=sql.90).aspx

Do you have access to a 2008 server?  They added quite a few tools to manager performance in 2008.

43

Web Server - Ask For Help / Re: Checking Fields in a form

« on: April 30, 2014, 11:33:36 AM »

Hi Brian

Try it like this
p_web.gsv('CVF:EditsCompleted') => p_web.gsv('CVF:EditsRequired')

Debra

44

Web Server - Ask For Help / Re: live graphs using a free javascript library

« on: April 30, 2014, 04:46:52 AM »

I have used http://www.highcharts.com/.  Its free for non-commercial use.  If you are after non-commercial let me know and I will see if I can get you some sample code.

Thanks,

Debra

45

Web Server - Ask For Help / Re: Function for Percent Encoding?

« on: April 30, 2014, 04:40:30 AM »

The flags is what I was missing...  I overlooked that somehow    

It almost gets me where I need to be with the net:dos, except I need the / encoded.  Or you could look at it another way, I need to keep the . with a non-flag encode.

I am doing oAuth, and I have to make the strings encoded in my signature.  So here is an example of a string as it has to be encoded for the signature to be valid
This is my string

Code: [Select]

oauth_callback='http://10.211.55.4:88/qbGetOAuthAccessToken'I need it to look like this

Code: [Select]

oauth_callback_Encoded = 'http%3A%2F%2F10.211.55.4%3A88%2FqbGetOAuthAccessToken'
p_web.encodeWebstring(oauth_callback,net:dos) gives me 'http%3A//10.211.55.4%3A88/qbGetOAuthAccessToken'

and

p_web.encodeWebstring(oauth_callback) gives me 'http%3A%2F%2F10%2E211%2E55%2E4%3A88%2FqbGetOAuthAccessToken'

Edit:
Here is a description of what I need:

Returns a string in which all non-alphanumeric characters except -_.~ have been replaced with a percent (%) sign followed by two hex digits. This is the encoding described in » RFC 3986 for protecting literal characters from being interpreted as special URL delimiters, and for protecting URLs from being mangled by transmission media with character conversions (like some email systems).

I found this here: http://stackoverflow.com/questions/996139/urlencode-vs-rawurlencode
Thank you!

Debra