-
Hi Stacie,
You'll need to use the alias surrounded by pound (number/hash) signs, like this:
<query database='#CMS#' table='MaxJobNumber'
maxrows='2'><columns><column
name='MaxJob'/></columns></query>
Can you try that and let us know if it works?
Thanks!
-
Ernesto,
I have already completed this step. Here is part of my web.config file where I added everything. My database server is aussql and the my db is CMS. Did I miss something?
<servers>
<server name="default" connectionString="Data Source=ausdev2;Integrated Security=True" ...
-
Hello,
I'm looking for a way to create a unique ID for each form submitted to a form library. Is there a way to accomplish this without any new downloads?
I use a combination of fields on the form and the date to create a name for the submitted form. An issue arises when someone tries to submit two forms with similar data on the ...
-
Hi Stacie,
Before you can begin using a database/table with the QueryDB web service, the database and table being queried need to be added to DBXL’s web.config file. You'll be adding a line like <database alias="DB_Alias" name="SampleDB" server="default" /> to the configuration/qdabra.dbxl/enumdb/databases ...
-
Hi
I have Master/Detail form
In the repeation section i would like to do some calculations.
for instance i would like to take fields from my datasource and multiply them to get the value for another field.
So Annual Interest Rate Only = MortgagteAmount * InterestRate
When i do this i get and Invalid Data (NaN): For every calculation:
This is ...
-
On my browser form I have a search box that should allow users to search existing forms in a document library. A list of the returned forms needs to be displayed on the form in a repeating table or such (paged, since there could be a lot of results). The user then needs to be able to select a row in the results and have the associated ...
-
Hi, I am receiving an error when trying to create a data connection. Here are my steps:
Add New Connection
Create new connection to receive data
Select Web Service
Key in web service details http://AUSDEV1/QdabraWebService/QueryDB.asmx?WSDL
Select GetColumnsXMLStrQuery
Enter Sample Value code (which I created from ...
-
Hi Vura,
DBXL works fine with InfoPath 2010, we have had customers using InfoPath 2010 Beta and RC1 with DBXL since Microsoft released these builds last summer.
If DBXL and SharePoint are on a different machine Query SharePoint will still work. Depending upon your environment there may be some authentication changes you need to make (such ...
-
Here's the scenario. I currently publish an xsn as "C:\Forms\Shipping Order.xsn". I place this file into two non-Sharepoint locations for two sets of users. The form is stored in location A as "Shipping Form.xsn". The problem is Location B stores the files and places in underscores in the name i.e., ...
-
Hi there,
Customer ask me to add something like a confirm message (visible or not dependind some conditions) in a browser forms using InfoPath Forms Services.
My idea was simply to use an section with conditional formatting
This form use code behind as submit options. 2 datas connections are using to submit to a ...