url question

[brazilhills]

Okay I'm totally not much of a web page person. I am using a URL in one application to open another webapp. I'm passing a dynamic medical record number to the other application using Search=Search&LockMRN=$$PERSON.MRN$$
which works great.
My problem is the MRN that is getting sent has 6 leading zeros because that is the way it is in the sending system. However in the receiving system the leading zeros do not exist so it doesn't link to the correct patient.
Any ideas on how to truncate the leading zeros if they exist?
thanks

 

[tperri]

Convert that value to an Int - that should do the trick.

 

[brazilhills]

How do I do that in the url string? I can't change the database, it is set the way it has to be set, proprietary software. Thanks

 

[ca8msm]

Before you add the value to the URL, use CInt() to convert it to an Integer ans then add it.


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[brazilhills]

okay you are talking to a dummy here, how do I do this?

 

[ca8msm]

How do you create the URL and redirect the user now?


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[brazilhills]

this is all I have to work with in the application. It is called an External Link in the application so that is all I can use....this URL works fine except I need to get rid of the leading zeros in pat.medrec

javascript:void(window.open('

http://pyramisweb/pyramisui/default.aspx?Search=Search&LockMRN=$$PAT.MEDREC$$

&user=$$DRS.HOSPID$$','Pyramis'));

Is it possible to truncate the string inside the URL because that is all we have to work with.
Thanks
and sorry to be such a dummy, the company is not helping at all so we have to figure this out on our own

 

[ca8msm]

I don't recognise the syntax for the variables that use $$. Is this an ASP.NET application and if so can you provide the full code for the page you are working on and how that link is embedded into the page?


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[brazilhills]

Not asp.net application. Only the company can supply the code and they won't do that. They are the ones that said to use the $$.
I'll try to email them again to see if they will help me.
Thanks for trying I do appreciate it

 

[ca8msm]

Not asp.net application.

This is the ASP.NET forum you are in. If the question is not ASP.NET related then I'm afraid we won't be much help. Try asking in the relevant forum.


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.