Limit Web Service Results to one first letter for alphabetic organizin

[nuwud]

I have a site that draws its listings from a 3rd party web service and get all of the results at once in one long list. I want to limit the yield of info to all the items that start with a number or punctuation, a, b, c, d, e, etc per page. A whole page for listings starting with "A" and so, on. How do I do that? I can show you the link, but I don't want to seem like I am shamelessly advertising in the forum.

The documentation for this web service is here:

http://tnwebservices-test.ticketnetwork.com/tnwebservice/v3.1/tnwebservicestringinputs.asmx

But the documentation makes little sense to me since I hardly code JavaScript to this degree and everything seems out of context.

To make matters worse, the site I am working on is in ASPX with a masterpagefile. I usually use PHP, so my familiarity is once again limited.

If you need more info, I am glad to share.

 

[BillyRayPreachersSon]

I'm not sure that this is a JavaScript question... it seems that you use a standard GET request to return results, and probably just need to put in a standard SQL 'where' clause to limit the items beginning with the letter you wish. For this reason, I'd suggest asking in one of the many SQL forums here instead of this forum.

I can't test this theory out as I don't have a valid 'websiteConfigID' to insert, nor do I know the correct SQL syntax without looking it up.

Hope this helps,
Dan



Coedit Limited - Delivering standards compliant, accessible web solutions

Dan's Page [blue]@[/blue] Code Couch:

http://www.codecouch.com/dan/

Code Couch Snippets & Info:

http://www.codecouch.com/

The Out Atheism Campaign

 

[nuwud]

Thanks for getting back to me.

I don't have access to the sql since this is a 3rd party service, but here is the code used to call it.

<script language="javascript" type="text/javascript">
document.write('<script language="javascript" src="

http://###########.com/?bid='+####+...t_names&pcatid=2&showcats=true&title=Concerts

Tickets"></' + 'script>');
</script>

Just a document.write element calling the 3rd party for info.

Does that help at all? If you give me an idea I will test it and let you know how it went.

 

[nuwud]

More info: I am not using SQL for this site on my end, although the site utilizes ASPX.

I believe a sort method might work...

 

[BillyRayPreachersSon]

I don't have access to the sql

You do have access to pass a 'whereClause' parameter through with your request, though, along with many other parameters.

Give it a try.

Dan




Coedit Limited - Delivering standards compliant, accessible web solutions

Dan's Page [blue]@[/blue] Code Couch:

http://www.codecouch.com/dan/

Code Couch Snippets & Info:

http://www.codecouch.com/

The Out Atheism Campaign

 

[nuwud]

That is awesome!!

I do see the 'whereClause' parameter you are talking about here:

http://tnwebservices-test.ticketnet...tnwebservicestringinputs.asmx?op=SearchEvents

How do I use that? How do I apply that to what I am trying to do?

Should I post in a section that isn't JavaScript? Which section would be best?

 

[nuwud]

I found this:

http://www.w3schools.com/Sql/sql_where.asp

but I still don't fully understand how to get only events beginning with 'A' to show.

 

[BillyRayPreachersSon]

I'd ask in one of the many SQL forums here, or try a search on Google for something like 'SQL begins with'.


Dan



Coedit Limited - Delivering standards compliant, accessible web solutions

Dan's Page [blue]@[/blue] Code Couch:

http://www.codecouch.com/dan/

Code Couch Snippets & Info:

http://www.codecouch.com/

The Out Atheism Campaign

 

[nuwud]

I started a new thread here:

http://www.tek-tips.com/viewthread.cfm?qid=1619151