Syntax

4 Topics

Uncaught SyntaxError in the Italian version of Login Page
Good morning, We've just installed the latest version of Windows Admin Center (2410) and when we try to login from the HTML form, we can't login and we get this error in console: Uncaught SyntaxError: Unexpected identifier 'accesso' (at (index):398:49) In fact, if you go to the exact line there is a syntax error due to the Italian translation of the string that adds a ' character that is not escaped. Is it possible to fix it in order to use the System language? Ty
lucasorberazsg
Aug 13, 2025 Place Windows Admin Center
61Views
0likes
0Comments
Syntax Error Help
I am trying to get data from 5 tables to show as one and if I just limit it to 2 tables this works, but when I add the further columns to select and the further tables to get the data from it fails. I am new to SQL and this is a massive learning curve for me. Please can someone sort this statement for me: SELECT A.ID, A.EXTERNAL_IDENTIFIER, A.FIRST_NAME, A.LAST_NAME, A.BIRTH_DATE, B.STATE_PROVINCE_ID, C.ASSISTANCE_DOG_NAME_8, C.DATE_OF_BIRTH_9, C.COLOUR_11, D.INVISIBLE_DISABILITIES_142, D.NON - VERBAL_148, D.HEARING_IMPAIRMENT_143, D.SIGHT_LOSS_144, D.BLADDER_BOWEL_WEAKNESS_ILLNESS_145, D.MOBILITY_146, E.END_DATE, E.MEMBERSHIP_TYPE_ID FROM `CiviCRM-3134371907`.civicrm_contact A, `CiviCRM-3134371907`.civicrm_address B, `CiviCRM-3134371907`.civicrm_value_assistance_do_2 C, `CiviCRM-3134371907`.civicrm_value_medical_condi_3 D, `CiviCRM-3134371907`.civicrm_membership E WHERE A.ID = B.ID, A.ID = C.ENTITY_ID, A.ID = D.ENTITY_ID, A.ID = E.CONTACT_ID; Update: It says the error is in the WHERE statement, but I don't know how to fix it
djohnson-morris
Dec 13, 2022 Place SQL Server
565Views
0likes
0Comments
'Calling' a function from within a Word document
I know this is probably really basic but this will be my first real dive into Word VBA, I am quite experienced in Excel VBA, though. I am having difficulty getting my head around how Word 'knows' that a 'block of text' is code, rather than just text of the document. As my first 'excursion', within Word VBA, I am seeking to split a phrase, when it is passed, through mail merge, from an Excel spreadsheet to a Word document. With apologies for i. the fact that my interface to this forum does not permit me to see all the proper formatting options for code and ii. the following is more of a 'storyboard' version of code, rather than the proper thing. The relevant Excel spreadsheet is used to support a group of mail merge letters and this 'issue' is only relevant to one letter, so I do not wish to redesign the spreadsheet; I would prefer to handle the 'issue' within Word, through VBA code. I will focus on two mail merge fields, within this question. The 2 mail merge fields are called, for the sake of simplicity here, i) Relative_Name and ii) Relative_Relationship. Relative_Relationship contains, for example, the value "Second Cousin Twice Removed of the Husband of my Second Cousin Once Removed", and, just to make up a name, Relative_Name contains "Walter Gerard Montague". Now when I simply include the fields in the other letters I simply type - Based on reviewing the online tree which has brought you to my attention, I can see that your tree includes «Relative_Name». Your relationship to me: «Relative_Relationship». and I would end up with a final merged text that reads - Based on reviewing the online tree, which has brought you to my attention, I can see that your tree includes Walter Gerard Montague. Your relationship to me: Second Cousin Twice Removed of the Husband of my Second Cousin Once Removed. On this occasion, though I want to split the contents of the field Relative_Relationship into two halves, through passing it to a VBA macro, so that I would end up with - Based on reviewing the online tree, which has brought you to my attention, I can see that your tree includes Walter Gerard Montague. Walter Gerard Montague is the Husband of my Second Cousin Once Removed and you are his Second Cousin Twice Removed. Now for the sake of the following let's call the VBA function, which I propose to write, Relationship_Phrase_Split. Now here is the nub of my question, how does Word know I am invoking the subroutine when I write, in the mail merge document, something that maybe looks like - Based on reviewing the online tree, which has brought you to my attention, I can see that your tree includes «Relative_Name». Relationship_Phrase_Split(«Relative_Relationship», maybe some other fields from the Excel spreadsheet to control how the splitting is done, e.g. «Gender»). I have only italicised, in the above, just to highlight where I am needing assistance to understand how to cause Word to process the code. I am not asking for help on the split function, only the correct syntax for calling it, please. I have made the document a .docm extension. With thanks in anticipation. Philip Bendigo, Vioctoria
Solved
PMHunt1955
Jul 28, 2019 Place Word
4.1KViews
1like
2Comments
Vlookup Syntax Within Formatted Table / Structured Reference
AFternoon all, need help on syntax with Vlookups across two separate tables within the same workbook - text of my formula below - please let me know if any further info is needed: For referece: the vlookup is on a table named "Etran" (within a sheet labelled "Etran"), the data i am trying to pull back is on a table labelled "Assembly" (on a sheet named Assembly). Can anyone see what is causing errors with this syntax below? =VLOOKUP([@[Unit + Pt]],Assembly[@[Unit + Pt]]:Assembly[@[Iplan_ID]],30,0) Thanks! Joe
JoeCavasin
Dec 04, 2018 Place Excel
4KViews
0likes
1Comment