going to url with variables

[steve745]

Is there a way to use an button with on push to goto url like http://server.com/form.asp?name=var1&name2=var2 and so on so it opens the url like that var1 2 3 are going to contain a value from the form it is ran from.

[Stan Mathews]

Re: going to url with variables

sys_open("http://server.com/form.asp?name=var1&name2=var2")

or you mean like

var1 = "test"
var2 = "another"

sys_open("http://server.com/form.asp?name="+quote(var1)+"&name2="+quote(var2))

If var1 and var2 are character type.

[steve745]

Re: going to url with variables

well thats a hard question. I'm trying to pass variables on the form to my private server actual https:192.168.1.5/simpleform.asp
i have used what you posted with the +quote and think i have it now thank you

[steve745]

Re: going to url with variables

"https://192.168.1.5/simpleform.asp?x.card_num="+quote(X_card_num.value)
that works how would i add more variables in there to use
"https://192.168.1.5/simpleform.asp?x.card_num="+quote(X_card_num.value)&id=x.id.value&name=x.name.value

i don't know how to add more to the address with &blah=something&blah2=some
i've been trying

[Stan Mathews]

Re: going to url with variables

Think of strings enclosed in quotes. You want to concatenate several literal strings with dynamic values held in variables. Every time you want to insert a variable's value you have to end the current string ("), begin the concatenation (+), insert the variable's name/value, continue the concatenation (+), them begin the new literal string (").

[COLOR="Red"]"https://192.168.1.5/simpleform.asp?x.card_num="[/COLOR]+quote(X_card_num.value)+[COLOR="red"]"&id="[/COLOR]+quote(x.id.value)+[COLOR="red"]"&name="[/COLOR]+quote(x.name.value)

I have coded the literal strings in red to distinguish them.

[steve745]

Re: going to url with variables

thanks i'm going to study this all night till i get it right

[steve745]

Re: going to url with variables

Thanks stan that was the kick in the A** i needed now it's working the way i planned.

[steve745]

Re: going to url with variables

now here i run into where xbasic would help
i'm using action scripting to open a url and when i get so much info into the url it changes from type C to B
i'm thinking blob, is there another way to put this in an expresion or use convert_type() i tried but nothing worked. then when i go to open the url a get a var error

[Stan Mathews]

Re: going to url with variables

Alpha does an automatic conversion to blob when a character variable exceeds the built in 1023/1024 (?) character limit. That can't be avoided.

Can you post a screenshot of what you are doing with the AS? You may be able to store parts of the url in multiple character variables and concatenate them in the AS box. Using the example from the documentation...


They show the Url to Open as

="http://www.alphasoftware.com"

translatable to

="http:"+"//www."+"alphasoft"+"ware.com"

if you get my drift.

Build your desired url in parts, then concatenate it in the expression builder.

var1 = "http:"
var2="//www."
var3="alphasoft"
var4="ware.com"

The expression for Url to Open

=var1+var2+var3+var4

[steve745]

Re: going to url with variables

the project is a payment gateway use to process checks. there is a lot of fields to fill on an asp page. it would have to pass all the data in the url i don't think breaking it in parts will do it it's still going to be long as hell. everything after the .asp?is all the data passed to the server. wow the 1024 limit really put a crutch in my plans.

"https://192.168.1.5/simpleform.asp?uname="+quote(Uname.value)+"&x.cust_id="+quote(X_cust_id.value)+"&x.first_name="+quote(X_first_name.value)+"&x.address="+quote(X_address.value)+"&x.city="+quote(X_city.value)+"&x.state="+quote(X_state.value)+"&x.zip="+quote(X_zip.value)+"&x.routing="+quote(X_routing.value)+"&x.account_type="+quote(X_account_type.value)+"&x.account="+quote(X_account.value)+"&x.amount="+quote(X_amount.value)+"&trans_id="+quote(X_trans_key.value)
it's as C till the variables are set
then when i use the form that gets the variables and then check the url expresion it's as type B

[steve745]

Re: going to url with variables

can I store variables value in another variable there may be a way to work thru this

[steve745]

Re: going to url with variables

ok here is what i think might work just need a little help to do it
to get the value of the blob into a variable and then dim as c then open url based on var.value
something like that maybe

[Stan Mathews]

Re: going to url with variables

I have been gently reminded by Tom Cone that the limit is not on a character variable but on an expression. The AS is expecting a character expression which is limited in length to 1024 characters.

Thanks Tom

[MikeC]

Re: going to url with variables

Steven,
I'm not entirely certain this is the same scenario, but a way to avoid the 1024 character limit I have used for a particular case involving a long concantenation was this. I had a memo field which would not take a blob value as a memo is character. I found that by first writing the blob to a text file and then writing the text file to the memo table eliminated this issue.

''Blob to Memo script
' 'rvList is the variable that has the entire filter that is concantenated from
' '   several other variables.  If the number of characters exceeds 1023
' '   then it becomes a blob.
if len(rvList)>1023 then
    dim fptr as p
    dim mtbl as p
    mtbl=table.open("memo_tbl") 'table which contains a memo field

' 'following creates a text file called Memo_Blob and then writes the variable
' '  rvList's blob contents to this file
    fptr=file.create(a5.Get_Path()+"\\"+"Memo_Blob.txt",FILE_RW_SHARED)
    fptr.writeb(rvlist)
    fptr.flush()
    fptr.close()
xbasic_wait_for_idle() 
  dim fname as c
  fname=a5.Get_Path()+"\\"+"Memo_Blob.txt"
  mtbl.change_begin()

' 'following then reads the text file and writes the contents to the memo
' '   field.
  mtbl.Mlist_rpt.memo_read_from_file(fname)
  mtbl.change_end(.t.)
   mtbl.close()

xbasic_wait_for_idle()

' 'if the variable rvList is not a blob then simply set the memo value to it
 else
  'Set properties of 'Mlist_rpt' in Form 'Report_Filter' .
  topparent:Mlist_rpt.value = rvList
end if

Again, not entirely certain if it applies or not.

[steve745]

Re: going to url with variables

ok i'm getting closer
i created a script that uses SYS_RESOLVE_URL(https://192.168.1.5/simpleform.asp?uname="+quote(Uname.value)+"&x.cust_id="+quote(X_cust_id.value)+"&x.first_name="+quote(X_first_name.value)+"&x.address="+quote(X_address.value)+"&x.city="+quote(X_city.value)+"&x.state="+quote(X_state.value)+"&x.zip="+quote(X_zip.value)+"&x.routing="+quote(X_routing.value)+"&x.account_type="+quote(X_account_type.value)+"&x.account="+quote(X_account.value)+"&x.amount="+quote(X_amount.value)+"&trans_id="+quote(X_trans_key.value))

i get a bunch of blank spaces in the url and it only sends a certain info the blank spaces are where the rest of the url needs to be.

this is what is in my browser address bar

https://192.168.1.5/simpleform.asp?uname="Steven"&x.cust_id="1001-41-0214                                      "&x.first_name="steve                                                                                                                                                                                                                                                          "&x.address="4801 Grand Blvd                                                                                                                                                                                                                                                "&x.city="New Port Richey                                                                                                                                                                                                                                                "&x.state="FL